Re: Monday dumb question...

if you are on 9i or higher this will work:

select rownum-1 from dual connect by level <= 100

At 03:45 PM 1/8/2007, Shreeni wrote:
>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

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

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