[oracle] PL/SQL For loop 사용 샘플

DECLARE
   x NUMBER := 1000;
BEGIN
   FOR i IN 1..170 LOOP 
        x := x + 1; 
        INSERT INTO aa (aa,bb) VALUES('a1',x);
        INSERT INTO aa (aa,bb) VALUES('a2',x);
   END LOOP;
   COMMIT;
END;

 

자세히 설명 나온 곳 : http://www.gurubee.net/lecture/1056