Explain the usage of WHERE CURRENT OF clause in cursors ?

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

Will truncate release space?

0 Answers  


Do view contain data?

6 Answers   Ramco,


What are Global Temporary tables

3 Answers   IBM, TCS,


What are inbuilt functions in sql?

0 Answers  


What are the different types of dbms?

0 Answers  






What is right join sql?

0 Answers  


What does fetching a cursor do?

0 Answers  


What is the starting oracle error number?

0 Answers  


what is 'force view'?

3 Answers   Cap Gemini, SPIC,


What is sql profiling in oracle?

0 Answers  


Are stored procedures faster than queries?

0 Answers  


how many no of table can be join in a sql query.

4 Answers  


Categories