add dummy rows-2

WITH t AS (
   SELECT  1 c1,   100 C2, TO_DATE('24-MAY-13','dd-mon-rr') MYDATE FROM dual UNION ALL
   SELECT  2 c1,   200 C2, TO_DATE('24-MAY-13','dd-mon-yy') MYDATE FROM dual UNION ALL
   SELECT  2 c1,   201 C2, TO_DATE('24-MAY-13','dd-mon-yy') MYDATE FROM dual UNION ALL
   SELECT  3 c1,   300 C2, TO_DATE('24-MAY-13','dd-mon-yy') MYDATE FROM dual UNION ALL
   SELECT  4 c1,   400 C2, TO_DATE('24-MAY-13','dd-mon-yy') MYDATE FROM dual UNION ALL
   SELECT  6 c1,   600 C2, TO_DATE('24-MAY-13','dd-mon-yy') MYDATE FROM dual UNION ALL
   SELECT  1 c1,   150 C2, TO_DATE('25-MAY-13','dd-mon-yy') MYDATE FROM dual UNION ALL
   SELECT  2 c1,   250 C2, TO_DATE('25-MAY-13','dd-mon-yy') MYDATE FROM dual UNION ALL
   SELECT  3 c1,   350 C2, TO_DATE('25-MAY-13','dd-mon-yy') MYDATE FROM dual UNION ALL
   SELECT  4 c1,   450 C2, TO_DATE('25-MAY-13','dd-mon-yy') MYDATE FROM dual UNION ALL
   SELECT  5 c1,   550 C2, TO_DATE('25-MAY-13','dd-mon-yy') MYDATE FROM dual UNION ALL
   SELECT  7 c1,   750 C2, TO_DATE('25-MAY-13','dd-mon-yy') MYDATE FROM dual
)
SELECT mydate,c1_aux,c1,c2
FROM
      (SELECT level-1 c1_aux FROM dual CONNECT BY level<24) gen
      left join t
      PARTITION BY (mydate)
      ON c1=c1_aux
ORDER BY mydate,c1_aux;