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
- 2950 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 a heap related to database ?
1 Answers TCS, University of Edinburgh,
which is the best training centre for learning oracle?
what is the syntax of CREATE command?
When do we use group by clause in a sql query?
How to see the table columns used in an index?
State and explain about oracle instance?
How to use fetch statement in a loop?
Explain oracle instance.
How to add a new column to an existing table in oracle?
What is oracle used for?
How to insert a record into a table?
How to store pictures on to the database?
Oracle General 
