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
- 3376 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 use "startup" command to start default instance?
How to create lov dynamically at runtime & attach to text field?
How to run create database statement?
Explain an index segment?
What is the relation of a user account and a schema in oracle?
How to shutdown your 10g xe server?
What is an oracle function?
Point the difference between translate and replace?
Write a syntax for update query in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is the usage of merge statement?
Can you assign multiple query result rows to a variable?
Oracle General 
