FOR statement opens a cursor, executes one or more statements repeatedly for each row and closes the cursor.

Syntax:

FOR cur_name IN [(] select_stmt [)] LOOP
  statements
END LOOP;

Notes:

• You can refer to the cursor columns using cur_name.col_name syntax

Example:

FOR item IN (
    SELECT dname, loc as location
    FROM dept
    WHERE dname LIKE '%A%'
    AND deptno > 10
    ORDER BY location)
LOOP
  DBMS_OUTPUT.PUT_LINE('Name = ' || item.dname || ', Location = ' || item.location);
END LOOP;

Compatibility: Oracle, PostgreSQL and Netezza

Version: PL/HQL 0.03