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: