1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is the best strategy to use COMMIT in a pl/sql loop?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is the best strategy to use COMMIT in a pl/sql loop?..

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

What is the best strategy to use COMMIT in a pl/sql loop?..

Answer / anil_abbireddy

End of the Block

Is This Answer Correct ?    3 Yes 2 No

What is the best strategy to use COMMIT in a pl/sql loop?..

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

Post New Answer

More SQL PLSQL Interview Questions

Does oracle roll back the transaction on an error?

0 Answers  

how to shutdown mysql server? : Sql dba

0 Answers  

What is set serveroutput on in pl sql?

0 Answers  

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

what are the differences between char and varchar? : Sql dba

0 Answers  




What does count (*) mean in sql?

0 Answers  

How to get second highest salary from a table

3 Answers  

what is meant by nl2br()? : Sql dba

0 Answers  

What is PL/SQL Records?

0 Answers  

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

what are the differences between require and include, include_once and require_once? : Sql dba

0 Answers  

what is the use of set statement in tsql? : Transact sql

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories