JAVA

[DB][Oracle] 다중 Insert INSERT ALL구문 사용

오선지♬ 2024. 11. 30. 12:21
728x90
반응형
INSERT ALL
    INTO T_LD_EXHB_CLS (TENANT_CD, LD_CD, EXHB_CLS_TP, MEMO, INS_USER_CD, UPD_USER_CD)
    VALUES ('TNT202405280001', 'LD202410150002', '101', '내용1 내용2', 'US202305290057', 'US202305290057')
    INTO T_LD_EXHB_CLS (TENANT_CD, LD_CD, EXHB_CLS_TP, MEMO, INS_USER_CD, UPD_USER_CD)
    VALUES ('TNT202405280001', 'LD202410150002', '102', '내용1 내용2', 'US202305290057', 'US202305290057')
    INTO T_LD_EXHB_CLS (TENANT_CD, LD_CD, EXHB_CLS_TP, MEMO, INS_USER_CD, UPD_USER_CD)
    VALUES ('TNT202405280001', 'LD202410150002', '103', '내용1 내용2', 'US202305290057', 'US202305290057')
SELECT * FROM dual;
728x90
반응형