We can use savepoint. This transactional control statement can be used to

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

Question Posted / kalyan maddipati

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

Please Help Members By Posting Answers For Below Questions

How to use sql*plus built-in timers?

1200

How can you get sql*loader to commit only at the end of the load file? : aql loader

1014

Does execute immediate commit?

1219

What is the difference between sql and t sql?

1034

What is difference between sql and mysql?

1131

What is difference between mysql and postgresql?

1152

what are the join types in tsql? : Transact sql

1064

Which sql statement is used to delete data from a database?

957

how many sql ddl commands are supported by 'mysql'? : Sql dba

1022

what is the command line end user interface - mysql? : Sql dba

981

Which data dictionary views have the information on the triggers that are available in the database?

1236

How exception handling is done in advance pl/sql?

981

Can a foreign key have a different name?

940

What is difference sql and mysql?

986

What are the disadvantages of file system?

1267