Re: Monday dumb question...

see the first one google could find for me http://oraqa.com/2006/01/26/what-are-the-different-ways-to-generate-rows/

Or find a table with at least 100 rows and populate it with select rownum -1 from that_table (all_objects most probably will suffice).

Gints Plivna
http://www.gplivna.eu

2007/1/9, Shreeni <shreeni_at_sbcglobal.net>:
>
> What is the easiest way to populate a column with 0-99 without using a temp
> table but just plain SQL ?? :-(
>
> Thanks and have a good day.
>
> Shreeni

--
http://www.freelists.org/webpage/oracle-l