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
What is relationship? How many types of relationship are there?
Where can I learn sql for free?
what is schema? : Sql dba
Define implicit and explicit cursors.
What are the types of variable use in pl sql?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is the purpose of a secondary key?
What are the types of operators available in sql?
How many sectors are in a partition?
What does (*) mean in sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is sql mysql pl sql oracle?
What is compilation error in pl sql?
What are the two different parts of the pl/sql packages?
What is nosql example?