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.
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
Are you familiar with internet architecture of oracle apps 11i?
how can i print random rows in plsql table
Tell me how to debug the report?
What is oracle soa suite and what are its different components?
What is a value set? List its various types.
What are do's and dont's of Interface?
Can we create tables in apps schema?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
testing tools?
In support project one ticket alloted which steps follows manualy tell me ?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
What do you understand by soa and what are the benefits of using this architecture?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
tell my any difficult situtation you solved in your experience in your company?
What does appl_top directory contain?