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

define data blocks ? : Sql dba

0 Answers  

Types of optimization?

6 Answers   Microsoft,

Define a temp table?

0 Answers  

Explain Connect by Prior?

2 Answers  

how do you know the version of your mysql server? : Sql dba

0 Answers  

difference between SQL and C

1 Answers   Indus Software Technologies,

Can cursors be part of a trigger body?

0 Answers  

How do I truncate a word?

0 Answers  

How do I add a database to sql?

0 Answers  

Does group by remove duplicates?

0 Answers  

define different types of trigger. : Sql dba

1 Answers  

what is a constraint? Tell me about its various levels. : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories