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

Answers were Sorted based on User's Feedback



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

Answer / tulsi

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

Is This Answer Correct ?    19 Yes 2 No

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

Answer / rahul koshti

By using WHERE CURRENT OF clause you can update or delete
records from the table where CURSOR fetched the records. But
for this you MUST have to open cursor with the clause of
'FOR UPDATE [OF COLUMN_NAME]'.

Is This Answer Correct ?    7 Yes 1 No

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

Answer / nishi

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

Is This Answer Correct ?    2 Yes 0 No

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

Answer / amar_kondla

wherecurrent of clause means which is currently being modify
by the view,where not on dml

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

how to shut down the server with 'mysqladmin'? : Sql dba

0 Answers  

write the Sql query for creating database backup?

7 Answers   TCS,

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

What is the difference between unique and primary key constraints?

0 Answers  

What is offset in sql query?

0 Answers  

Explain two easy sql optimizations.

0 Answers  

What do you mean by query optimization?

0 Answers  

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 Answers   IBM,

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

Is like operator in sql case sensitive?

0 Answers  

What is a nested table in word?

0 Answers  

What is indexing oracle sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories