1SET SERVEROUTPUT ON
2 BEGIN
3 -- A PL/SQL cursor (google implicit cursor to know more about it)
4 FOR cursor1 IN (SELECT * FROM table1)
5 LOOP
6 DBMS_OUTPUT.PUT_LINE('Column 1 = ' || cursor1.column1 ||
7 ', Column 2 = ' || cursor1.column2);
8 END LOOP;
9 END;
10 /