RE: Monday dumb question...

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 9 Jan 2007 12:18:58 -0500
Message-ID: <D1DC33E67722D54A93F05F702C99E2A95E4512@usahm208.amer.corp.eds.com>

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

Received on Tue Jan 09 2007 - 11:18:58 CST