Daily Oracle

short Oracle take-away tips that you can put to use in under an hour.

Tuesday, May 10, 2005

N dates on the go from DUAL



select * from (select TO_DATE ( '1-feb-04') + level from dual connect by level < 100)

Links

N numbers on the go from DUAL



select * from (select level from dual connect by level < N)

Links