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
- 3364 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 |
How to update values on multiple rows in oracle?
How to get a list of all user accounts in the database?
What are the limitations of check constraint?
How to create an oracle database?
How to pass parameters to procedures?
Can objects of the same Schema reside in different tablespaces.?
What is a database schema in oracle?
Explain the difference between sap and oracle?
What would you do if a database crashes in production?
What are the set operators union, union all, minus & intersect meant to do?
Does rowid change in oracle?
what happened to the global index when I truncate the data in one of the partition?
Oracle General 
