WITH t(store, team, brand_class, sum) AS
(
SELECT 30, 17, '01', 10000000 FROM dual
UNION ALL SELECT 30, 17, '02', 20000000 FROM dual
UNION ALL SELECT 30, 20, '01', 44545454 FROM dual
UNION ALL SELECT 30, 20, '02', 45454333 FROM dual
UNION ALL SELECT 30, 50, '02', 22234533 FROM dual
)
SELECT t.store
     , t.team
     , c.brand_class
     , t.sum
  FROM (SELECT '0'||LEVEL brand_class FROM dual CONNECT BY LEVEL <= 2) c
  LEFT OUTER JOIN t
  PARTITION BY (t.store, t.team)
    ON (c.brand_class = t.brand_class)
;