What is the best strategy to use COMMIT in a pl/sql loop?
- 3 Answers
- 9259 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
Why do you partition data?
what is a trigger? : Sql dba
What is a left inner join?
how are mysql timestamps seen to a user? : Sql dba
what are properties of a transaction? : Sql dba
Explain the order of sql statement execution?
What is procedure explain with example?
What is sql clause?
What is plpgsql language?
Explain clause in sql?
How to add new employee details in an employee_details table with the following details
What is nosql vs sql?
What is scope of pl sql developer in future?
what is cursor. write example of it. What are the attributes of cursor.
Is sql better than access?
