DEVFYI - Developer Resource - FYI

What WHERE CURRENT OF clause does in a cursor?

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

539. What WHERE CURRENT OF clause does in a cursor?

LOOP
SELECT num_credits INTO v_numcredits FROM classes
WHERE dept=123 and course=101;
UPDATE students
FHKO;;;;;;;;;SET current_credits=current_credits+v_numcredits
WHERE CURRENT OF X;

Other Interview Questions