DEVFYI - Developer Resource - FYI

What is a cursor for loop ?

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

494. What is a cursor for loop ?

Cursor for loop implicitly declares %ROWTYPE as loop index,opens a cursor, fetches rows of values from active set into fields in the record and closes when all the records have been processed.
eg. FOR emp_rec IN C1 LOOP
salary_total := salary_total +emp_rec sal;
END LOOP;

(Continued on next question...)

Other Interview Questions