oracle 대량 데이터 삽입

SQL> begin
  2  for i in 1..90000 loop
  3  insert into test11 values (i);
  4  end loop;
  5  commit;
  6  end;
  7  /

 

INSERT INTO Orders VALUES (2, 3, 1, 21000, TO_DATE('2021-12-24','yyyy-mm-dd'));
INSERT INTO Orders VALUES (3, 5, 2, 8000, TO_DATE('2021-12-24','yyyy-mm-dd')); 
INSERT INTO Orders VALUES (4, 6, 3, 6000, TO_DATE('2021-11-30','yyyy-mm-dd')); 
INSERT INTO Orders VALUES (5, 7, 4, 20000, TO_DATE('2021-11-30','yyyy-mm-dd'));
INSERT INTO Orders VALUES (6, 2, 1, 12000, TO_DATE('2022-05-28','yyyy-mm-dd'));
INSERT INTO Orders VALUES (7, 8, 4, 13000, TO_DATE( '2022-05-28','yyyy-mm-dd'));
INSERT INTO Orders VALUES (8, 8, 4, 13000, TO_DATE( '2022-05-28','yyyy-mm-dd'));
INSERT INTO Orders VALUES (8, 10, 3, 12000, TO_DATE('2022-05-28','yyyy-mm-dd')); 
INSERT INTO Orders VALUES (9, 10, 2, 7000, TO_DATE('2022-04-30','yyyy-mm-dd')); 
INSERT INTO Orders VALUES (10, 8, 3, 13000, TO_DATE('2022-04-30','yyyy-mm-dd'));



INSERT INTO Orders VALUES (2, 1, 3, 21000, TO_DATE('2021-12-24','yyyy-mm-dd'));
INSERT INTO Orders VALUES (3, 2, 5, 8000, TO_DATE('2021-12-24','yyyy-mm-dd')); 
INSERT INTO Orders VALUES (4, 3, 6, 6000, TO_DATE('2021-11-30','yyyy-mm-dd')); 
INSERT INTO Orders VALUES (5, 4, 7, 20000, TO_DATE('2021-11-30','yyyy-mm-dd'));
INSERT INTO Orders VALUES (6, 1, 2, 12000, TO_DATE('2022-05-28','yyyy-mm-dd'));
INSERT INTO Orders VALUES (7, 4, 8, 13000, TO_DATE( '2022-05-28','yyyy-mm-dd'));
INSERT INTO Orders VALUES (8, 3, 10, 12000, TO_DATE('2022-05-28','yyyy-mm-dd')); 
INSERT INTO Orders VALUES (9, 2, 10, 7000, TO_DATE('2022-04-30','yyyy-mm-dd')); 
INSERT INTO Orders VALUES (10, 3, 8, 13000, TO_DATE('2022-04-30','yyyy-mm-dd'));



INSERT INTO Book VALUES(4, '골프 바이블', '대한미디어', 35000);
INSERT INTO Book VALUES(5, '피겨 교본', '굿스포츠', 8000);
INSERT INTO Book VALUES(6, '역도 단계별기술', '굿스포츠', 6000);
INSERT INTO Book VALUES(7, '야구의 추억', '이상미디어', 20000);
INSERT INTO Book VALUES(8, '야구를 부탁해', '이상미디어', 13000);
INSERT INTO Book VALUES(9, '올림픽 이야기', '삼성당', 7500);
INSERT INTO Book VALUES(10, 'Olympic Champions', 'Pearson', 13000);