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_at_gmail.com] Sent: Monday, January 08, 2007 4:53 PM
To: shreeni_at_sbcglobal.net
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_at_sbcglobal.net> 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

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