2021. 3. 15. 1:28 기본 begin for i in [시작수]..[만들갯수] loop insert into [테이블명] (컬럼명1, 컬럼명2, 컬럼명3) values (컬럼1에 들어갈 값, 컬럼2에 들어갈 값, 컬럼3에 들어갈 값); end loop; end; 예시 create SEQUENCE ex_seq3 INCREMENT by 1 start with 8000; begin for i in 1..1000 loop insert into emp (empno, ename, job, mgr, hiredate, sal, comm, deptno) values (EX_SEQ3.nextval, 'test', 'test', 0, SYSDATE, 0, 0, 10); end loop; end; commit;