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
3375 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

What is blob data type in oracle?

1123

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2971

What is memory advisor in Oracle?

1077

What is a snapshot in oracle database?

1025

What is an oracle user account?

993

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2397

What are the differences between interval year to month and interval day to second?

1028

What is raw datatype in oracle?

1136

How can Oracle users be audited?

1116

Describe varray?

1059

Where do we use decode and case statements?

1013

What is the relationship among database, tablespace and data file?

989

Can a formula column referred to columns in higher group ?

2506

What is the dynamic sql in oracle?

1073

How to invoke the data pump export utility?

1187