[Oracle] 다른테이블정보로 Insert하기

 
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.CRSE_CD
                                          AND student.INFO_SERL_NUM = '9'
                                          AND student.PLAN_CD = 'TN0003'
                                          AND student.USE_YN = 'Y')))