3 methods to generate rows
May 9th, 2008SELECT ROWNUM n
FROM
( SELECT 1 just_a_column
FROM dual
GROUP BY CUBE(1,2,3,4,5,6,7,8,9)
)
WHERE ROWNUM <= 365
SELECT ROWNUM n
FROM
( SELECT 1 just_a_column
FROM dual
[...]
