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
- 7353 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 |
Can you explain the difference between architecture followed in 10g & 11g?
where we will put the control file ,where we will run sql star loader what is the cmd?
what is user exit and wat program do we write in user exit?
How many phases of implementation and what are those.
hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me
2 Answers Pathway Technologies,
What repots or concurrent program run to transfer data from Inventory to GL.
What are the tables in GL?
Is that Possible To create package without Specification , If Yes Give any Examples
what is instead of trigger. what is the use of that?
why r u move in the cus_top only why not move another top
What do you understand by concurrent programs?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
Oracle Apps Technical 
