What is the best strategy to use COMMIT in a pl/sql loop?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kalyan maddipati
We can use savepoint. This transactional control statement
can be used to save records at perodic intervals
Is This Answer Correct ? | 0 Yes | 0 No |
How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)
How would you hide a table in sql. ie the table can be only visible to its maker?
how a reference cursor works?what all adnvantages are gained with it..specify the situation?
HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)
What is the use of procedures?
What is not in sql?
How many clustered indexes can you have?
What are tables in sql?
Can we insert in view in sql?
What is the difference between a database and a relational database?
Why do we use function in pl sql?
What does subquery mean in sql?