다른테이블정보Insert1 [Oracle] 다른테이블정보로 Insert하기 123456789101112131415161718 INSERT INTO TEST_SEND (TRANS_SEQ) SELECT 'EP' || LPAD (VI_SEQ.NEXTVAL, 10, 0) FROM TEST_RECV WHERE TRANS_SEQ IN (SELECT DISTINCT TRANS_SEQ FROM TB_VIO WHERE MEM_NM||MEM_BRITH_DT IN ( SELECT MEMINFO_NM||MEMINFO_DT FROM (SELECT student.MEMINFO_NM AS EDUSNT_NM, student.MEMINFO_BIRTH_DT FROM TB_MEMINFO student, WHERE plan.PLAN_CD = student.PLAN_CD AND plan.CRSE_CD = crse... 2018. 7. 15. 이전 1 다음