Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3439 Views
- MasterCard, I also Faced
- E-Mail Answers
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 cartesian product?
How does oracle handle read consistency?
How to define a variable of a specific record type?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is an Oracle index?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
How to find no of saturdays in a month using single sql ?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What is an oracle cursor variable?
What is Parallel Server ?
How to display row numbers with the records?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
Oracle General 
