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

Does sqlite need a server?

1096


What is bulk compiling in pl/sql.?

1188


What is the syntax and use of the coalesce function?

1211


Is vs as in pl sql?

1036


How long it takes to learn pl sql?

1064


what is innodb? : Sql dba

1163


What is constant in pl sql?

1060


What are the different types of a subquery?

1101


What is cursor status?

1235


What is the most important ddl statements in sql are?

1042


Advantages and disadvantages of stored procedure?

1165


What is use of trigger?

984


Enlist the advantages of sql.

1052


what is auto increment? : Sql dba

1049


Which command is used to delete a package?

1231