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...

Explain the usage of WHERE CURRENT OF clause in cursors ?

Answer Posted / vipul varshney

It allows to apply updates and deletes to the row currently
being addressed, without the need to explicitly reference
the ROWID.
You must include the FOR UPDATE clause in the cursor query
so that the rows are locked on OPEN.

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I kill a query in postgresql?

1074


What are pl/sql cursor exceptions?

1076


What does := mean in pl sql?

1030


What is a sql*loader control file?

1232


Why is normalization important?

1008


Is microsoft sql free?

1083


Why do we use function in pl sql?

1045


What are the popular database management systems in the it industry?

979


What are sql triggers used for?

980


Explain what is rdbms?

1017


Is pl sql better than sql?

1009


Is sql a backend?

1002


What is the purpose of a sql?

961


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1181


What is a Mapplet?

1113