Re: Oracle SQL syntax

johnnie.ng2_at_gmail.com wrote:
> 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>
>

This is SQL standard. Either you us * alone in the select list or, preceded by a tablename.

The idea is:
SELECT T.*, S.* FROM T, S Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab