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
- 3380 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 recovery manager in Oracle?
How do I find my oracle client driver version?
What is oracle database client?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
What is a parameter file in oracle?
What is a SNAPSHOT ?
How many types of tables supported by oracle?
what is reindexing?
how to do daily transactions with out sql* loader control file regesterd in apps?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
Oracle General 
