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
- 10164 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 to set up sql*plus output format in oracle?
How to use boolean type in select statement?
How can you save or place your msg in a table?
What is rowtype?
what is a constraint? : Sql dba
What is sql rowcount?
Why use truncate instead of delete?
What is dynamic sql in pl sql?
Can sql function call stored procedure?
how to select unique records from a table? : Sql dba
Can we enter data in a table in design view?
Does pl sql work in mysql?
Why partition by is used in sql?
Can we alter stored procedure?
What is the difference between left outer join and left join?
