WITH t1 AS
(
SELECT 1 seq, '홍길동1' name, '000-111-222' contact, 'aaa@aaa.com' email, '서울시 강남구 도곡동' address FROM dual
UNION ALL SELECT 2, '홍길동2', '000-222-333', 'bbb@aaa.com', '대전시 대덕구' FROM dual
)
, t2 AS
(
SELECT 1 seq, '전문학사' school_name, '물리' major, '19980102' entsdate, '19990201' entedate, '10' grade, '12' lastgrade FROM dual
UNION ALL SELECT 1, '석사'    , '수학', '19990202', '19990201', '12', '13' FROM dual
UNION ALL SELECT 2, '전문학사', '물리', '19980102', '19990201', '10', '12' FROM dual
UNION ALL SELECT 2, '석사'    , '수학', '19990202', '19990201', '12', '13' FROM dual
)
SELECT a.seq
     , a.name, a.contact, a.email, a.address
     , b.school_name1, b.major1, b.entsdate1, b.entedate1, b.grade1, b.lastgrade1
     , b.school_name2, b.major2, b.entsdate2, b.entedate2, b.grade2, b.lastgrade2
  FROM t1 a
     , (SELECT seq
             , MIN(DECODE(rn, 1, school_name)) school_name1
             , MIN(DECODE(rn, 1, major      )) major1
             , MIN(DECODE(rn, 1, entsdate   )) entsdate1
             , MIN(DECODE(rn, 1, entedate   )) entedate1
             , MIN(DECODE(rn, 1, grade      )) grade1
             , MIN(DECODE(rn, 1, lastgrade  )) lastgrade1
             , MIN(DECODE(rn, 2, school_name)) school_name2
             , MIN(DECODE(rn, 2, major      )) major2
             , MIN(DECODE(rn, 2, entsdate   )) entsdate2
             , MIN(DECODE(rn, 2, entedate   )) entedate2
             , MIN(DECODE(rn, 2, grade      )) grade2
             , MIN(DECODE(rn, 2, lastgrade  )) lastgrade2
          FROM (SELECT seq, school_name, major, entsdate, entedate, grade, lastgrade
                     , ROW_NUMBER() OVER(PARTITION BY seq ORDER BY entsdate) rn
                  FROM t2
                )
         GROUP BY seq
        ) b
 WHERE a.seq = b.seq
;

감사하다는 글을 적고 싶었는데 일때문에 못들어왔네요.

해결되었습니다.

다시한번 감사드립니다.