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
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 |
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
How to create a purchase order without a requisition?
Hoe to skip middle of the record by using SQL*Loader?
What is profile and what is level of profile option and it's hierarchy
Explain the multi-organization structure.
is it possible to run the interface without using oracle apps?
In which table or database definition we can find the link of organization and operation units.
how to make a parameter optional in the query?
what is MRC? Why it is needed?
How to create user and how u attach with responsibility.
name all status attributes.
why we can use synonym?