Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Monday dumb question...

RE: Monday dumb question...

From: Shreeni <shreeni_at_sbcglobal.net>
Date: Mon, 8 Jan 2007 17:11:51 -0600
Message-ID: <005501c7337a$6199bb00$7008580a@shreenivasa>


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
Received on Mon Jan 08 2007 - 17:11:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US