(DB) Oracle/PL.SQL
Oracle - Procedure 문법_LOOP문
농부지기
2017. 1. 21. 13:54
[ 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;
...