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
- 10141 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 do you take the union of two tables in sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
How to read/write files from pl/sql?
What is the use of & in pl sql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Is sql better than excel?
What is difference between table and view?
what is foreign key? : Sql dba
Does group by remove duplicates?
What is cursor in pl sql with examples?
Explian rowid, rownum?
Can instead of triggers be used to fire once for each statement on a view?
what are the 'mysql' command line options? : Sql dba
Inline the values in PL/SQL, what does it mean.?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
