[Oracle] 오라클 반복문 FOR, LOOP, WHILE DECLARE ID_CNT VARCHAR2(10) :=1; BEGIN --X의 레코드 수만큼 반복 FOR X IN ( SELECT RECORD_ID FROM TABLE WHERE RECORD_ID LIKE '2%' ) LOOP WHILE ID_CNT '0' LOOP UPDATE TABLE SET COL = "" WHERE RECORD_ID = X.RECORD_ID; ID_CNT := 0; END LOOP; END LOOP; END;