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
- 3443 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 |
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
What is Database Trigger ?
What is an UTL_FILE.What are different procedures and functions associated with it?
can you write commit in triggers?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How are Indexes Update ?
What is an oracle user account?
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
Explain an extent?
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
What happens if the imported table already exists?
Can you tell me how to add new column in existing views?how?How is possible?
Oracle General 
