WITH t AS
(
SELECT '2017. 9. 1' dt, '미니미' nm, 1000 amt FROM dual
UNION ALL SELECT '2017. 9. 1', '미니미', 1000 FROM dual
UNION ALL SELECT '2017. 9. 3', '미니미', 1000 FROM dual
UNION ALL SELECT '2017. 9. 4', '미니미', 1000 FROM dual
UNION ALL SELECT '2017. 9. 5', '미니미', 1000 FROM dual
UNION ALL SELECT '2017. 9. 1', '즈'    , 2000 FROM dual
UNION ALL SELECT '2017. 9. 3', '즈'    , 2000 FROM dual
UNION ALL SELECT '2017. 9. 5', '즈'    , 2000 FROM dual
UNION ALL SELECT '2017. 9. 5', '즈'    , 2000 FROM dual
)
-- Oracle
SELECT a.dt
     , b.nm
     , NVL(b.amt, 0)
  FROM (SELECT DISTINCT dt FROM t) a
  LEFT OUTER JOIN
       (SELECT dt, nm
             , SUM(amt) amt
          FROM t
         GROUP BY dt, nm
        ) b
 PARTITION BY (b.nm)
    ON a.dt = b.dt
 ORDER BY nm, dt
;

-- MySQL
SELECT a.dt
     , b.nm
     , IFNULL(c.amt, 0) amt
  FROM (SELECT DISTINCT dt FROM t) a
 CROSS JOIN
       (SELECT DISTINCT nm FROM t) b
  LEFT OUTER JOIN
       (SELECT dt, nm
             , SUM(amt) amt
          FROM t
         GROUP BY dt, nm
        ) c
    ON a.dt = c.dt
   AND b.nm = c.nm
 ORDER BY nm, dt
;

mysql은 partition outer join이 없나보네요. dt와 nm cross join 성능이 어떨지..