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
- 3283 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 |
How to define an external table with a text file?
How will you identify oracle database software release?
how do u setup a replication site?
Explain can a view based on another view?
How to check your oracle database 10g xe installation?
What is Index and different types of Indexes?
What's dateware house and what's clustor with practicle example
What is a Data Dictionary ?
Explain integrity constraint?
How do I learn what codesets are available in oracle?
What is a Data Segment ?
What is Network Database link ?
Oracle General 
