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
- 2960 Views
- MasterCard, I also Faced
- E-Mail Answers
Answer Posted / ana
Use bulk collect limit 5000 and forall with save exceptions and in exception block rollback
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is recovery manager(rman) backup in Oracle?
What is the difference between truncate & delete command?
What operating systems are supported by oracle database 10g xe?
What is the quickest way to fetch the data from a table?
What is a cursor and what are the steps need to be taken?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What happens if you use a wrong connect identifier?
how the indexes are stored in the Oracle Database?
What is columnar storage what is the advantage?
How to add another datafile to a tablespace?
Please explain compound trigger in oracle?
How to get execution statistics reports on query statements?
what is the difference between substr and instr function in oracle?
How to delete multiple rows from a table in oracle?
