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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Explain the usage of WHERE CURRENT OF clause in cursors ?

Question Posted / vipul varshney

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

Can two tables have same primary key?

977

What is dml statement?

957

what are date and time data types in mysql? : Sql dba

971

How do you create a unique index?

1049

how can you create an empty table from an existing table? : Sql dba

1154

Is sql similar to python?

977

How global cursor can be declare with dynamic trigger ?

2210

What is a trigger word?

1026

what is the difference between delete and truncate statement in sql? : Sql dba

1247

Is nosql faster than sql?

1024

What is the difference between Union and Union all. Which is faster.

1403

Is grant a ddl statement?

897

How to run sql*plus commands in sql developer?

1159

Mention what does the hierarchical profiler does?

1091

What is pl sql script?

1035