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 |
How to store pictures on to the database?
How to apply filtering criteria at group level in oracle?
how the indexes are stored in the Oracle Database?
How to create a table in a specific tablespace?
what is the difference between rollback & commit? can a foreign key has null value?
select trunc(round(156.00,-1),-1) from dual;
How to define an external table with a text file?
how to find the n'th highest salary from emp ?
Differnce between view and index
What are Schema Objects ?
which clause we are not used in where clause?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables