RE: Monday dumb question...

Thanks Venkat....this is just what the doctor ordered .....whooohooo
 
Thanks and have a good day.
 
Shreeni
(630) 401-2887 (Mobile)
(630) 837-1730 (Home)

 

  _____  

From: Venkat Krish [mailto:venkat.lear@xxxxxxxxx] 
Sent: Monday, January 08, 2007 4:53 PM
To: shreeni@xxxxxxxxxxxxx
Subject: Re: Monday dumb question...


insert into <<your table>> select level from dual connect by level<100;
 
or (
insert into <<your table>>
select rownum from 
(select object_name from all_objects where rownum<=10) a,
(select object_name from all_objects where rownum<=10) b
where rownum<100

 
On 1/8/07, Shreeni <shreeni@xxxxxxxxxxxxx> 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


Other related posts: