RE: Monday dumb question...
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 9 Jan 2007 12:18:58 -0500
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:
