RE: Monday dumb question...

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  

• Mark D Powell -- Phone (313) 592-5148

  ---

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