---   row수 많은 테이블 만들기

conn scott/tiger@192.168.186.3:1521/orcl.oracle.com

drop table tm
/
drop sequence tm_s
/
CREATE TABLE TM(ID NUMBER(10),DATA VARCHAR2(30),
           CONSTRAINT TM_PK PRIMARY KEY(ID))
/
create sequence tm_s
/
create or replace procedure tm_i(su number)as
 begin
    for i in 1..su loop
            insert into tm values(tm_s.nextval,'aaaa');
            commit;
    end loop;
 end;
/
exec tm_i(1000)
/
select count(*) from tm
/