Database/Oracle
[query] 다중 insert 오라클 쿼리
denodo
2015. 3. 19. 16:29
방법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);