Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle SQL syntax

Oracle SQL syntax

From: <johnnie.ng2_at_gmail.com>
Date: Wed, 28 Nov 2007 18:03:24 -0800 (PST)
Message-ID: <b317e9b8-126a-45e2-aef0-fac9dadf6d64@d4g2000prg.googlegroups.com>


Can anyone explain the following strange behaviour in Oracle SQL?

SQL> select * from dual;

DU
--

X

SQL> select dummy from dual;

DU
--

X

SQL> select dummy, * from dual;
select dummy, * from dual

              *
ERROR at line 1:
ORA-00936: missing expression

SQL> select dummy, a.* from dual a;

DU DU
-- --

X X

SQL> Received on Wed Nov 28 2007 - 20:03:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US