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

Home -> Community -> Usenet -> c.d.o.misc -> Re: trying to convert sql left outer join to oracle

Re: trying to convert sql left outer join to oracle

From: Frank <fbortel_at_home.nl>
Date: Thu, 19 Dec 2002 19:35:01 +0100
Message-ID: <3E021155.7060302@home.nl>


Greg wrote:
> I don't think Oracle supports the "AS" keyword. I ran into that when
> I started using Oracle.
>
> Good luck!

SQL> select to_char(sysdate,'DD-MON-YYYY') as "You're wrong" from dual;

You're wrong



19-DEC-2002 It does. In another context perhaps. Received on Thu Dec 19 2002 - 12:35:01 CST

Original text of this message

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