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

What is relationship? How many types of relationship are there?

1174


Where can I learn sql for free?

982


what is schema? : Sql dba

1047


Define implicit and explicit cursors.

1143


What are the types of variable use in pl sql?

1075


how tsql statements can be written and submitted to the database engine? : Transact sql

987


What is the purpose of a secondary key?

964


What are the types of operators available in sql?

1060


How many sectors are in a partition?

1076


What does (*) mean in sql?

948


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1000


What is sql mysql pl sql oracle?

1067


What is compilation error in pl sql?

974


What are the two different parts of the pl/sql packages?

1083


What is nosql example?

1032