Interested to Buy Any Domain ? << Click Here >> for more details...
What is the best strategy to use COMMIT in a pl/sql loop?
- 3 Answers
- 10285 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudhakar naraparaju
It depends on the number of records being looped. If it is
a huge table then it is better to commit after a specific
number of transactions are completed. Even better to do
inside the loop so that the data is commited for every set
looped.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How do I count records in sql?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is the largest value that can be stored in a byte data field?
How do I start sql profiler?
What are the properties of a transaction?
How to rename a table?
What is bind reference and how can it be created?
what is the difference between myisam static and myisam dynamic? : Sql dba
What are the types of dbms?
What is pl sql collection?
Does a primary key have to be a number?
what are integrity rules?
What is interval partition?
When is the update_statistics command used?
What are different joins used in sql?
