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

How can you fetch first 5 characters of the string?

0 Answers  

Is inner join faster than left join?

0 Answers  

How many types of cursors are available in pl/sql?

0 Answers  

How can you fetch common records from two tables?

0 Answers  

Where the Pre_defined_exceptions are stored ?

2 Answers  




Is sql a programming?

0 Answers  

What is mutating trigger?

0 Answers  

What are the different types of joins and explain them briefly.

3 Answers  

How to find last day of the month in sql query

4 Answers  

Can we insert data into materialized view?

0 Answers  

function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,

what is the different between now() and current_date()? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories