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 difference between DBMS and RDBMS?
Explain the types of exception?
How to change system global area (sga) in oracle?
How to create index-by table in oracle?
What is Database Link ?
Explain overloading. Can functions be overloaded?
How to delete multiple rows from a table in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
what is port in oracle? how is it related to database application.
What are Schema Objects ?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?