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
- 7829 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 |
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
What is responsibility and how u attach
why r u transer the data base tables to flat file and what is use
After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?
Define MultiOrg Structure
Can u attach Request set with in the Request set?
what is the difference between procedure and function
in which tables the transaction details stored? at least two.
What is the difference between base table and multi-org table?
which parameters passed in report in oracle developer how to pass
we have 10 records. It's occured error in 6th record how can u find and how to rectify that?
link between po and ap modules
Oracle Apps Technical 
