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.
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 parameterized cursor in oracle?
What is procedure overloading in oracle?
i want department wise maxmum salary and empolyee name
What are the different types of modules in oracle forms?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is a cursor in oracle?
Explain the use of record option in exp command.
How to use null as conditions in oracle?
How to delete an existing row from a table in oracle?
How to omit columns with default values in insert statement in oracle?
what is the difference between rollback & commit? can a foreign key has null value?
What is oracle open database communication (odbc)?