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
|