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
- 3268 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 difference between sid and service name in oracle?
what are the database links ?
What are the factors causing the reparsing of SQL statements in SGA?
What is logical backup in oracle?
How do I spool to a csv formatted file using sqlplus?
What is a Database instance ? Explain?
How does oracle handle read consistency?
how to clone 9i Database on to 10g Database.
what is the output of select * from emp where null=null & select * from emp where 1=1
How are the index updates?
Explain the use of online redo log files in oracle.
How to find the duplicate rows count from employees table in oracle?
Oracle General 
