Oracle - Procedure 문법_FOR_LOOP문

[ Oracle - Procedure 문법_FOR_LOOP문 ]

 

1.문법

    FOR index in [REVERSE] lower_bound..upper_bound LOOP

          statement;

    END LOOP;

2.예제

  ex) 우선 set serveroutput on을 한다.

       CREATE OR REPLACE PROCEDURE iterate

          (v_lower NUMBER,    v_upper NUMBER)

       IS

           v_counter NUMBER(10) := 0;

           v_output NUMBER(10);

       BEGIN

           FOR i IN v_lower..v_upper LOOP

                  v_counter := v_counter + 1;

                  v_output := i;

           END LOOP;

 

           DBMS_OUTPUT.PUT_LINE('Last value is '||TO_CHAR(v_output)  ||'. Total loops = '||TO_CHAR(v_counter));

      END iterate;

3. 예제 2

    설명 : - 1~150까지 1씩 증가 하면서 LOOP를 돈다.

    문법 :

          FOR nLoop IN 1..150 LOOP

                 ............

          END LOOP;