PL/SQL 샘플 데이터 만들기 (대용량 데이터 만들기)

#테이블과 인덱스 생성
CREATE TABLE usertable_many(userid VARCHAR2(20), password VARCHAR2(20), nickName VARCHAR2(20), 
email VARCHAR2(30), class VARCHAR2(30), ages VARCHAR2(30));
CREATE INDEX idx_userid ON usertable_many(userid); 

#PL/SQL
DECLARE
TYPE tbl_ins IS TABLE OF usertable_many%ROWTYPE INDEX BY BINARY_INTEGER;
w_ins tbl_ins;
BEGIN
FOR i IN 1..14000 LOOP 
   w_ins(i).userid :=i;
   w_ins(i).password :=i;
   w_ins(i).nickName :='name';
   w_ins(i).email :=i;
   w_ins(i).class :=i;
   w_ins(i).ages :=i;
END LOOP;
   FORALL i in 1..14000 INSERT INTO usertable_many VALUES w_ins(i);
   COMMIT;
END;
/

#생성데이터 조회
select count(*) from usertable_many;

#일부만 조회
select * from usertable_many
where rownum <= 3;