Use bulk collect limit 5000 and forall with save exceptions and in exceptio

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.

Question Posted / ana

1 Answers
3343 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

Please Help Members By Posting Answers For Below Questions

How to convert a string to a date in oracle database?

1030

Explain oracle 12c new features for developers?

1023

What are named parameters?

1071

List out the difference between commit, rollback, and savepoint?

1015

What is Virtual Private Database in Oracle?

1060

Which is better Oracle or MS SQL? Why?

6338

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1925

How to execute the package in oracle?

1066

What happens to the current transaction if a ddl statement is executed?

990

Can group functions be used in the order by clause in oracle?

981

What is Data Dictionary Cache in Oracle?

1142

Is the After report trigger fired if the report execution fails ?

2900

How to generate query output in html format?

1089

How to create tables for odbc connection testing?

1081

Why we use bulk collect in oracle?

1011