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
- 2620 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
How to convert a string to a date in oracle database?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Which environment variables are absolutely critical in order to run the OUI?
How to insert multiple rows with one insert statement in oracle?
Is the After report trigger fired if the report execution fails ?
How to find the duplicate rows count from employees table in oracle?
How to write a query with an inner join in oracle?
How to define a procedure inside another procedure?
What is a dynamic performance view in oracle?
What is columnar storage what is the advantage?
Explain about functional dependency and its relation with table design?
State any two functions of oracle?
Explain view?
How to define a data field as not null?
Explain the use of show option in imp command.
