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 / swapna

Answers were Sorted based on User's Feedback



Explain the usage of WHERE CURRENT OF clause in cursors ?..

Answer / madhuri

WHERE CURRENT OF clause is used to update the current row of
the active set of a cursor

Is This Answer Correct ?    11 Yes 1 No

Explain the usage of WHERE CURRENT OF clause in cursors ?..

Answer / swapna

WHERE CURRENT OF clause in an UPDATE,DELETE statement
refers to the latest row fetched from a cursor.

Is This Answer Correct ?    10 Yes 2 No

Explain the usage of WHERE CURRENT OF clause in cursors ?..

Answer / 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

More SQL PLSQL Interview Questions

can we create index on index?

7 Answers   iFlex, Symphony,

what are dynamic queries in t-sql? : Transact sql

0 Answers  

When the mutating error will comes? and how it will be resolved?

2 Answers  

What is an Exception ? What are types of Exception ?

2 Answers  

how to add a new column to an existing table in mysql? : Sql dba

0 Answers  

Does group by remove duplicates?

0 Answers  

how to write date and time literals? : Sql dba

0 Answers  

How many databases can sql express handle?

0 Answers  

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

What is a join?Explain the different types of joins?

6 Answers   Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,

What is sql table?

0 Answers  

Why sql query is slow?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories