There is always a question in mind that how to connect to the oracle?I already given information about Oracle database management system in my previous…
View More How to connect Oracle without tnsnames.oraAuthor: Amit S
Oracle Consultant with vast experience in Oracle BI and PL/SQL Development. Amiet is the admin head of this website who contributes by preparing tutorials and articles related to database technologies. He is responsible to manage the content and front-end of the website.
How to check Oracle client is 32 bit or 64 bit?
In my previous articles i have given the detailed level idea about the multiple types of errors in oracle.I would like to give you detailed…
View More How to check Oracle client is 32 bit or 64 bit?SQL Quiz Competition
During this Pandemic period. Lets have some Fun and Win exciting prizes up to $500. You can prepare for the interview and Win the exciting…
View More SQL Quiz CompetitionORA-03135: connection lost contact
In my previous articles i have given detailed idea about multiple database and oracle errors. In this article i would like to give more information…
View More ORA-03135: connection lost contactGather stats in Oracle : Schema,Tables and Indexes
In my previous articles i have given idea about the performance tuning techniques,Indexes in sql.In any performance tuning technique we require to create multiple indexes…
View More Gather stats in Oracle : Schema,Tables and IndexesORA-01157: cannot identify/lock data file string – see DBWR trace file
In my previous article i have given the idea about different errors coming in Oracle. In my last article i have given the idea about…
View More ORA-01157: cannot identify/lock data file string – see DBWR trace fileORA-27101: shared memory realm does not exist
In my previous articles i have given the basic idea about multiple oracle errors in detail. I have given the one by one errors.In this…
View More ORA-27101: shared memory realm does not existHow to UPDATE bulk of records in Oracle Database
In my previous article i have given the idea about how to update the records in sql. In this article i would like to give…
View More How to UPDATE bulk of records in Oracle DatabaseHow to calculate total size of the database
In my previous articles i have given the basic idea about the converting seconds in to time format and viceversa. In this article i would…
View More How to calculate total size of the databaseHow to convert seconds in time format in SQL
In my previous article i have given the basic idea about how to convert time to seconds. In this article i would like to give…
View More How to convert seconds in time format in SQL