WITH t1 AS
(
SELECT '이름1' nm, 'A011' cd, 10 amt FROM dual
UNION ALL SELECT '이름1', 'A02', 20 FROM dual
)
, t2 AS
(
SELECT '이름1' nm, 'D01' cd, 30 amt FROM dual
UNION ALL SELECT '이름1', 'D02', 40 FROM dual
UNION ALL SELECT '이름1', 'D03', 50 FROM dual
UNION ALL SELECT '이름1', 'D04', 60 FROM dual
)
SELECT nm
     , rn
     , MIN(cd1 ) cd1 
     , MIN(amt1) amt1
     , MIN(cd2 ) cd2 
     , MIN(amt2) amt2
  FROM (SELECT ROW_NUMBER() OVER(PARTITION BY nm ORDER BY cd) rn
             , nm
             , cd   cd1
             , amt  amt1
             , null cd2
             , null amt2
          FROM t1
         UNION ALL
        SELECT ROW_NUMBER() OVER(PARTITION BY nm ORDER BY cd) rn
             , nm
             , null cd1
             , null amt1
             , cd   cd2
             , amt  amt2
          FROM t2
        )
 GROUP BY nm, rn
 ORDER BY nm, rn
;