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

What are different types of functions in sql?

0 Answers  

How do you determine the current isolation level? : Transact sql

0 Answers  

What is sql server and ase?

0 Answers  

What is intersect?

1 Answers  

How to update salary of employees department wise?

6 Answers  

What is sql in java?

0 Answers  

Which table is left in join?

0 Answers  

What is pragma in pl sql?

0 Answers  

What is sql*loader and what is it used for?

0 Answers  

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

2 Answers  

What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,

What do you understand by pl/sql records?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories