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
- 8443 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
How to create a purchase order without a requisition?
Tell me how to debug the report?
What are file in oracle.
Tell me where we find the status of order information?
how can i print random rows in plsql table
What does appl_top directory contain?
tell me the scenarios of the independent in reports
Can you explain the difference between architecture followed in 10g & 11g?
Do you know what are user profiles in apps. Any examples you can give?
Can you define an erp system?
Are you familiar with internet architecture of oracle apps 11i?
can we use look up type instead of a pofile option?or valueset?is it possible how?
do you know is it possible to run the interface without using oracle apps?
How do you register report in oracle apps?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
