Google News
logo
PL/SQL - Interview Questions
What is the use of WHERE CURRENT OF in cursors?
We use this clause while referencing the current row from an explicit cursor. This clause allows applying updates and deletion of the row currently under consideration without explicitly referencing the row ID.

Syntax : UPDATE table_name SET field=new_value WHERE CURRENT OF cursor_name
Advertisement