Oracle PL-SQL Question:
Download Questions PDF

What is a cursor for loop?

Answer:

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;

Download Oracle PL-SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What is an oracle stored procedure?What are the cursor attributes used in PL/SQL?