DB
[DB][Oracle] 다중 Insert UNION ALL 사용
오선지♬
2024. 11. 29. 20:20
728x90
반응형
INSERT INTO T_LD_EXHB_CLS (
TENANT_CD, LD_CD, EXHB_CLS_TP, MEMO, INS_USER_CD, UPD_USER_CD
)
SELECT 'TNT202405280001', 'LD202410150002', '101', '내용1 내용2', 'US202305290057', 'US202305290057' FROM DUAL
UNION ALL
SELECT 'TNT202405280001', 'LD202410150002', '102', '내용1 내용2', 'US202305290057', 'US202305290057' FROM DUAL
UNION ALL
SELECT 'TNT202405280001', 'LD202410150002', '103', '내용1 내용2', 'US202305290057', 'US202305290057' FROM DUAL;
MySQL 과 다르게 SELECT 할때 FROM DUAL 해주기
728x90
반응형