How to insert records into Oracle db table if I got error while inserting 4th record then how to insert 5th,6th.... records continuously

Sunil Borra

• Sep 6th, 2018

I am pretty sure that unless you correct the 4th rec or remove it altogether from all the other inserts you would not make past the 4th insert. How are you inserting the data by the way?

Answer Question  Select Best Answer

How to find out the max high value using varray?

Kaushik Nayak

• Jan 19th, 2018

Code
 

Answer Question  Select Best Answer

Magu

• Aug 5th, 2007

Isolated join is a join which is not connected to any of the context.

Answer Question  Select Best Answer

Prashanth

• Apr 28th, 2006

is it drived ? Are you sure ..I think is is Derived.

Answer Question  Select Best Answer

In oracle we are using dual table name for the temporary purpose. which table we are using in SQL server

gheibia

 Profile Answers by gheibia Questions by gheibia

• Mar 23rd, 2006

The SELECT command'S syntax in SQL Server is different than Oracle.In SQL Server you don't need (always) to select data from a source (using FROM).you can just select a variable.What SQL Server dose i...

Answer Question  Select Best Answer

Oracledba

• May 2nd, 2006

V$backup : This status column of this view shows whether a tablespace in hot backup mode.The status 'ACTIVE'  shows the datafile to be in backup mode.V$datafile_header : The fuzzy column also hel...

Answer Question  Select Best Answer

If we create a table having a column of BLOB data type then how we have to insert and retrieve the data?

Mahim Mishra

• Jul 8th, 2006

We can Read and Write BLOB Data to a Database Table Through an Anonymous PL/SQL Block .The primary advantage of using anonymous PL/SQL blocks is improved performance -they can be used to batch a ser...

Answer Question  Select Best Answer

How to repair the tnsnames.ora file.
File is completely corrupted and you get network adapter errors and TNS resolve error after restarting the machine.

dbxplorer

 Profile Answers by dbxplorer Questions by dbxplorer

• Jul 21st, 2011

Delete or rename the older file and try to recreate it using "netmgr" using proper information of your database.

Answer Question  Select Best Answer

What is meant by Remote Backup?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

Suppose as a client u connected to server with the help of some third party tool and you are going to take backup from your server then that is called remote backup.

Answer Question  Select Best Answer

Explain in detail what are bdump, cdump & udump?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

background dump (bdump) :--. > bdump is used for all the issues raised related to background process in our database. its also contain alert .log which contain all activities and issues related to da...

Answer Question  Select Best Answer

What is the use of catalog and no catalog in RMAN?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

Rman with catalog means our target database registered in catalog and its used for recovery purpose. its containing metadata about to database.

rman with no catalog means metadata stored in controlefile through the controlfile we can do the recovery.

Answer Question  Select Best Answer

How to give private and public database links ?What is syntax for that ?What means mutation in oracle??

dbxplorer

 Profile Answers by dbxplorer Questions by dbxplorer

• Jul 21st, 2011

Database link is the pointer that allow users to access other user's object in remote database. This is one way communication path using database links. Private db links: CREATE DATABASE LINK link_na...

Answer Question  Select Best Answer