230306 [SQL] (다중 INSERT)

1. 다중 INSERT

-- 문법 : 
INSERT INTO (column1, column2, ...)
SELECT value1, value2, ... FROM DUAL 
UNION ALL
SELECT value1, value2, ... FROM DUAL
...
UNION ALL
SELECT value1, value2, ... FROM DUAL;

 ex)

CREATE TABLE TEST_STU (
    STU_NUM NUMBER PRIMARY KEY
    , STU_NAME VARCHAR2(50)
    , STU_AGE NUMBER
);

INSERT INTO TEST_STU (STU_NUM, STU_NAME, STU_AGE)
SELECT 1, '김길동', 20 FROM DUAL
UNION ALL
SELECT 2, '이길동', 30 FROM DUAL
UNION ALL
SELECT 3, '박길동', 40 FROM DUAL;