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 are the usage of SAVEPOINTS?

Answer Posted / bindhu

Savepoints are used to create marker in the current
transaction by using SAVEPOINT statement which divides the
transaction into smaller section. We can then dicard
pending changes up to that marker by using the ROLLBACK TO
SAVEPOINT statement.

Is This Answer Correct ?    19 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of the primary key?

1063


Why stored procedure is faster than query?

1062


What are the different sql languages?

1035


Mention what are different methods to trace the pl/sql code?

1205


how to calculate expressions with sql statements? : Sql dba

1034


What is PL/SQL Records?

1189


How does cross join work?

956


What are all the ddl commands?

1183


Can a foreign key be a duplicate?

911


Can we insert in sql function?

1084


What is a temp table?

1024


What is information schema in sql?

1070


Can we commit in trigger?

976


What are the rules to be applied to nulls whilst doing comparisons?

1323


What will you get by the cursor attribute sql%found?

963