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
- 10151 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
What is self-join and what is the requirement of self-join?
what is the difference between union and union all? : Sql dba
what is the difference between delete and truncate statement in sql? : Sql dba
What is rtm in testing?
how to add a new column to an existing table in mysql? : Sql dba
What is substitution variable in pl sql?
Difference between global and parameter variables?
Differentiate pl/sql and sql?
What are the ddl commands?
Explain dml and ddl?
Why do we create views in sql?
How many unique keys can a table have?
What are the two types of exceptions.
What is a natural join sql?
Mention what does the hierarchical profiler does?
