[DATABASE/ORACLE] 커서 사용하기

 

SET SERVEROUTPUT ON;

 

    CURSOR EMPLOYEE_CURSOR IS

        SELECT * FROM SCOTT.EMP;

 

    V_EMPLOYEE_RECORD EMPLOYEE_CURSOR%ROWTYPE;

    OPEN EMPLOYEE_CURSOR;

 

    LOOP

        FETCH EMPLOYEE_CURSOR INTO V_EMPLOYEE_RECORD;

 

        EXIT WHEN EMPLOYEE_CURSOR%NOTFOUND;

 

        DBMS_OUTPUT.PUT_LINE(V_EMPLOYEE_RECORD.ENAME);

    END LOOP;

 

    CLOSE EMPLOYEE_CURSOR;

END;