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
3272 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 calculate date and time differences in oracle?

994

State all possible different index configurations a table can possibly have?

951

What is a directory object?

1032

List the parts of a database trigger.

990

what is reindexing?

1611

Please explain drop constraint oracle?

1030

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

954

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

979

Explain what are synonyms used for?

986

How to assign query results to variables?

1013

11. Display the client number and name and the client number and name of the person who referred that client.

2278

What is set operator oracle?

923

What privilege is needed for a user to create indexes in oracle?

965

How to sort the query output in oracle?

972

Can we convert a date to char in oracle and if so, what would be the syntax?

960