Interested to Buy Any Domain ? << Click Here >> for more details...
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
- 1 Answers
- 3351 Views
- MasterCard, I also Faced
- E-Mail Answers
Answer / ana
Use bulk collect limit 5000 and forall with save exceptions and in exception block rollback
| Is This Answer Correct ? | 1 Yes | 1 No |
What is parameterized cursor in oracle?
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Is it possible to disable the parameter from while running the report ?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
What is system tablespace?
How to start a specific oracle instance?
structural difference between bitmap and btree index ?
How to find out what oracle odbc drivers are installed?
What is an Integrity Constrains ?
How to create a new view in oracle?
Oracle General 
