RE: Monday dumb question...

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 09 Jan 2007 10:36:22 -0700
Message-Id: <20070109173543.4C06B58FE59@turing.freelists.org>

Jared pointed that out to me privately. It DOES work in the context of a CTAS or insert ... select which is what I understood the OP wanted. I was just too lazy to type more than the select part. I use that trick al the time for test cases.

10:33:34 ora92.scott> select banner from v$version;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production PL/SQL Release 9.2.0.7.0 - Production
CORE 9.2.0.7.0 Production
TNS for 32-bit Windows: Version 9.2.0.7.0 - Production NLSRTL Version 9.2.0.7.0 - Production

5 rows selected.

10:33:58 ora92.scott> create table mark as select rownum id from dual connect by level <= 10;

Table created.

10:34:26 ora92.scott> select * from mark;

         ID

---

          1
          2
          3
          4
          5
          6
          7
          8
          9
         10

10 rows selected.

10:34:31 ora92.scott> insert into mark select rownum+1000 id from dual connect by level <= 15;

15 rows created.

10:34:58 ora92.scott> select * from mark;

         ID

---

          1
          2
          3
          4
          5
          6
          7
          8
          9
         10
       1001
       1002
       1003
       1004
       1005
       1006
       1007
       1008
       1009
       1010
       1011
       1012
       1013
       1014
       1015

25 rows selected.

10:35:03 ora92.scott>

That's what you get for being lazy. Now I had to type even more.

At 10:18 AM 1/9/2007, Powell, Mark D wrote:
>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
>

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

---

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

---

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 09 2007 - 11:36:22 CST