Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2066


Can we use update in sql function?

1112


What is identity column in sql server?

1100


What is a composite primary key?

1140


What is query syntax?

1017


What is null in pl/sql?

1117


What is update query?

1028


What are schema-level triggers?

1149


What is group by in sql?

1124


What is difference between pl and sql?

1109


Which software is used for pl sql programming?

1033


what is collation? : Sql dba

1198


What is cursor status?

1233


How to avoid using cursors?

1175


What are all types of user defined functions?

1131