Interested to Buy Any Domain ? << Click Here >> for more details...
I am insert in data to a table X .Which one is better while
writing commit statement
After each row inset or after all row insert to table.
- 3 Answers
- 8393 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
I think its better to use the savepoint when ever u want to
save till the specific insert.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kiddu
the best way is committing after all rows inserted but suppose we are using a proc that is inserting huge data suppose 4k or 5k records then its better to commit in every 1000 records to avoid "Snapshot too old error".
| Is This Answer Correct ? | 0 Yes | 0 No |
what is multi org structure?
what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions
Is that Possible To create package Overloading , If Yes Give any Examples
what do u mean by debit/credit memo invoices?
3 Answers ACC, Convergys, Mascon,
What is cursor?
How to send the e-mail notification in XML Pub Report?
In which directory your flatfile is given?if u connected different instance where it is find?
What do you understand by concurrent programs?
What are different execution methods of executabls?
Stored procedure?
what is the difference between procedure and function
I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.
1 Answers Genpact, Y3K Imaginations,
Oracle Apps Technical 
