[query] 다중 insert 오라클 쿼리

방법1:

INSERT ALL

INTO table (column1, column2)

VALUES (value1, value2)

INTO table (column1, column2)

VALUES (value1, value2)

...etc...

SELECT * FROM DUAL;

방법2:

INSERT INTO table (column1, column2)

SELECT value1, value2 FROM DUAL UNION ALL

SELECT value1, value2 FROM DUAL UNION ALL

...etc...

SELECT value1, value2 FROM DUAL;

DBMS Tool 1:

INSERT INTO table (column1, column2) VALUES (value1, value2);

INSERT INTO table (column1, column2) VALUES (value1, value2);

INSERT INTO table (column1, column2) VALUES (value1, value2);

INSERT INTO table (column1, column2) VALUES (value1, value2);

INSERT INTO table (column1, column2) VALUES (value1, value2);

...etc...

INSERT INTO table (column1, column2) VALUES (value1, value2);