ORACLE : CURSOR Sample Script

DECLARE
    CURSOR CUR IS
        SELECT PRJT_CODE, OPER_CMPN
        FROM JATU100
        WHERE BANK_CMPN = '1018516025';
       
    JATU_REC CUR%ROWTYPE; 
   
BEGIN
    OPEN CUR;
    LOOP 
        FETCH CUR INTO JATU_REC;
        EXIT WHEN CUR%NOTFOUND;
       
        -- 하고자 하는 일을 하자... ;
        -- DO_SOMETHING();
        UPDATE JATU100
        SET PRJT_CODE = NULL
        WHERE 1=2;

        DBMS_OUTPUT.PUT_LINE(TO_CHAR(CUR%ROWCOUNT));
       
    END LOOP;
   
    CLOSE CUR;
END;