Re: select * from dual in MOUNTED database returns 4 columns (one row)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 9 Jul 2002 19:40:10 +0100
Message-ID: <1026239948.15625.0.nnrp-01.9e984b29@news.demon.co.uk>

I (always) understand the point about scale and the momentum / inertia problem, but the thing that surprises me is the way the 'obvious' handful that could make a real difference are missed. Such as in STANDARD.SQL (now stdbody.sql)

  function USER return varchar2 is
  c varchar2(255);
  begin

        select user into c from sys.dual;
        return c;

  end;

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            July / Sept
        Australia      July / August
        Malaysia        September
        USA (MI)        November
http://www.jlcomp.demon.co.uk/seminar.html

Pete Sharman wrote in message ...


>                      We ended up creating a synonym SYSTEM.DUAL instead

>of changing all the code.  Same sort of thing for the Oracle code I

suspect.


>You're probably never going to see a project "let's change every reference

to


>DUAL to X$DUAL" in any Oracle release, but you may see that change made

>gradually as other projects work on those specific parts of the code.

>

Received on Tue Jul 09 2002 - 13:40:10 CDT