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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

how can you create an empty table from an existing table? : Sql dba

858


What is sqlexception in java?

732


What is string data type in sql?

724


how to create a table index in mysql? : Sql dba

748


What is the command used to fetch the first 5 characters of a string?

922






What type of database is cloud sql?

778


Why are aggregate functions called so?

681


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

735


How do I remove sql plus from windows 10?

765


Which join is default?

709


Explain some predefined exceptions.

778


What is before trigger?

735


how can we know the count/number of elements of an array? : Sql dba

772


Can we rollback delete command?

692


Which is faster subquery or join?

850