Re: "un-grouping" results

Not sure where your going with this?

SQL> select rownum from dual
connect by 1=1
and rownum < 999 ;

    ROWNUM

         1

So I tried to use it instead of the cube syntax:

  1 select *
  2 from (
  3 select rownum r from dual
  4 connect by 1=1
  5 and rownum < 999 ) a,
  6 exp
  7* where exp.num >= a.r
SQL> /          R ID NUM
---------- -- ----------

         1 Z          10
         2 Z          10
         3 Z          10
         4 Z          10
         5 Z          10
         6 Z          10
         7 Z          10
         8 Z          10
         9 Z          10
        10 Z          10
         1 Y          25
         2 Y          25
         3 Y          25
         4 Y          25
         5 Y          25
         6 Y          25
         7 Y          25
         8 Y          25
         9 Y          25
        10 Y          25
        11 Y          25
        12 Y          25
        13 Y          25
        14 Y          25
        15 Y          25
        16 Y          25
        17 Y          25
        18 Y          25
        19 Y          25
        20 Y          25
        21 Y          25
        22 Y          25
        23 Y          25
        24 Y          25
        25 Y          25

35 rows selected.

Can anyone get it to work? Received on Sat Feb 05 2005 - 18:53:29 CST