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
- 9953 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
What is a recursive stored procedure?
Is nosql relational?
How many row comparison operators are used while working with a subquery?
What is join view in sql?
what are all different types of collation sensitivity? : Sql dba
what is log shipping? : Sql dba
What are views in sql?
Why is %isopen always false for an implicit cursor?
Can we use view in stored procedure?
What does sql stand for?
Is crud a cuss word?
How do you concatenate in sql?
Are stored procedures compiled?
How do you modify a trigger?
What is rowid in sql?
