Sign Up Login


  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

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

How do I order by ascending in sql?

0 Answers  

What is sql partition function?

0 Answers  

What are the types of functions in sql?

0 Answers  

Does google use sql?

0 Answers  




Name the different types of indexes in sql and define them.

0 Answers  

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 Answers   IBM, TCS,

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

1 Answers   Metric Stream,

Does pl/sql support create command?

0 Answers  

which will fire first ? Trigger or Constraint

24 Answers   i2, IBM,

What are the types of views in sql?

0 Answers  

what is row? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories