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
- 8292 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
What is a value set? List its various types.
Do you know where we can check the status of po?
What are the benefits of using soa architecture?
What is sca and how is it useful?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
how do you describe O2C along with tables
What do you understand by concurrent programs?
Tell me how to find the custom directory in front end?
How many schemas we have? how many you have used?
what is global tempory table?
Plz anybody send me Technical specification for AP Interface
please send me forms, xml pulisher questions,answers
What are file in oracle.
where to define interorganization transaction charges and what are the different options?
