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
- 8312 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
is it possible to run the interface without using oracle apps?
Is soa a part of oracle fusion middleware?
Do you know what are user profiles in apps. Any examples you can give?
what are the different transaction clauses in AR?
How to create a purchase order without a requisition?
What do you understand by concurrent programs?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
How can we import the data into a database using sql * loader?
In oracle application how do you debug or trace errors?
what are the balancing segments in AR?
do you know is it possible to run the interface without using oracle apps?
What does appl_top directory contain?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What are the benefits of using soa architecture?
Can you differentiate between mediator and osb?
