nickjoIT
While Loop 본문
DECLARE
l_cnt NUMBER := 0;
BEGIN
WHILE l_cnt<=3 LOOP
UPDATE emp SET comm=0 WHERE empno=7900+l_cnt;
l_cnt:=l_cnt+1;
END LOOP;
ROLLBACK;
END;
/
Comments
DECLARE
l_cnt NUMBER := 0;
BEGIN
WHILE l_cnt<=3 LOOP
UPDATE emp SET comm=0 WHERE empno=7900+l_cnt;
l_cnt:=l_cnt+1;
END LOOP;
ROLLBACK;
END;
/