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
|