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: Tue, 9 Jan 2007 11:38:23 -0600
Message-ID: <000c01c73414$f65822f0$7008580a@shreenivasa>


But this worked for me as proposed by Venkat...  

insert into <<your table>> select level from dual connect by level<100;  

Thanks and have a good day.  

Shreeni
(630) 401-2887 (Mobile)
(630) 837-1730 (Home)
 


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark D
Sent: Tuesday, January 09, 2007 11:19 AM To: oracle-l_at_freelists.org
Subject: RE: Monday dumb question...

This proposed solution does not appear to work on 9.2.0.6 running on AIX 5.2  

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production  

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

  ROWNUM-1


         0  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling
Sent: Monday, January 08, 2007 7:36 PM
To: shreeni_at_sbcglobal.net
Cc: oracle-l_at_freelists.org
Subject: 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.centrexcc.com/>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 09 2007 - 11:38:23 CST

Original text of this message

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