Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle SQL syntax
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