Oracle - Procedure 문법_LOOP문

[ Oracle - Procedure 문법_LOOP문 ]

 

1. 문법

LOOP

 

statement;

...

EXIT [WHEN condition];

 

END LOOP;

 

2.예제

   ex) ...

          v_ord_id s_item.ord_id%TYPE := 101;

          v_counter NUMBER(2) := 1;

        BEGIN

          ...

        LOOP

          INSERT INTO s_item (ord_id, item_id)

          VALUES (v_ord_id, v_counter);

                        v_counter := v_counter + 1;

        EXIT WHEN v_counter > 10;

        END LOOP;

         ...