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.
Answers were Sorted based on User's Feedback
Answer / anu
after all row insert into table
|Is This Answer Correct ?||5 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|
How to develop XML report without rdf?
what is multi org structure?
what is instead of trigger. what is the use of that?
How we print the multi language in report?can any one give me step bye step explanation.
How to know the number of invoices generated for one PO from front end (navigation)?
What do you understand by a set of books?
Except the SRS window in which we can submit the concurrent program.
explain o2c cycle? what are the table reflected for this process?
how to change the logo in template dynamically?
Please let me know the differance between Master Item and organization Item in Inventory.
what is the difference between oracle applications ebs 11.5.9 and 18.104.22.168 and can anyone suggest the release dates of the versions
How many standard interface programs in oracle purchasing module and oracle inventory? What are they?