PL/SQL CURSOR 예제

DECLARE
  CURSOR CSR_1 IS SELECT ...
                    FROM ...;
  S_COL_1 VARCHAR2(10);
  S_COL_2 VARCHAR2(10);
  ...
BEGIN
    OPEN CSR_1;
    LOOP
        FETCH CSR_1 INTO S_COL_1, S_COL_2, ...;
        EXIT WHEN CSR_1%NOTFOUND;
       
        ...
       
    END LOOP;
    CLOSE CSR_1;
   
END;