Interested to Buy Any Domain ? << Click Here >> for more details...
What is the best strategy to use COMMIT in a pl/sql loop?
- 3 Answers
- 10105 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How exception handling is done in advance pl/sql?
What is sql not null constraint?
Do we need to create index on primary key?
How to select 10 records from a table?
Explain constraints in sql?
Can we have two clustered index on a table?
Explain the savepoint statement.
Does oracle roll back the transaction on an error?
How to Declare Fixed Length String Value In PL SQL
How to avoid duplicate records in a query?
How do I edit a trigger in sql developer?
What are different types of indexes?
Can we use the cursor's to create the collection in PL/SQL?
What is t sql in sql server?
What is procedure and function in sql?
