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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Powell, Mark D
Sent: Tuesday, January 09, 2007 11:19 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Wolfgang Breitling
Sent: Monday, January 08, 2007 7:36 PM
To: shreeni@xxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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/>

Other related posts: