[Sql] Oracle - 간단한 저장프로시저

create sequence TEST_SEQ;
commit;

-----------0--------------------0------------------------0--------------

create or replace procedure PROC_INSERT(nCount NUMBER)
is

loop_val number := 0;

begin

for i in 1..nCount loop
        insert into TEST_TB(TESTEID) values(TEST_SEQ.NextVal);
end loop;

end PROC_INSERT
/
commit;
-----------0--------------------0------------------------0--------------

exec PROC_INSERT(10000);