Cursor com Oracle

 BEGIN

-- Create cursor and start loop

FOR C_PAR in (SELECT * FROM TGFPAR WHERE CODPARC < 100) LOOP

-- run commands for each item here

DBMS_OUTPUT.PUT_LINE(C_PAR.CODPARC || ' - ' || C_PAR.RAZAOSOCIAL);

END LOOP;

END;

Resultado: