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
- 8457 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 |
name all status attributes.
what is the error you will get if field is referenced in wrong repeating frame?
How to develop XML report without rdf?
A file has both header and corresponding lines. Explain design to load this data into respective interface tables.
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Where I can download D2K software?
what is the defference between credit memo and debit memo
what are the match approvals in PO?
What is SET-OF-BOOKS?
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
what is the database size you used?
In which directory your flatfile is given?if u connected different instance where it is find?
Oracle Apps Technical 
