Re: SQL about "as"

From: Madhu Cherukuri <Madhu.Cherukuri_at_nospam.usa.net>
Date: 21 Nov 1998 02:02:35 GMT
Message-ID: <36561F77.2315F72D_at_nospam.usa.net>


AS is used to represent a column alias.
[Quoted] Like this

        select T.branchname AS "Branch Name"
        from branch
        where T.branchname="city";


HTH Madhu Cherukuri

Ken Ho Kwok Fai wrote:

> I am using oracle 8 in unix. I write the following
> SQL but it seems to have some problems.
>
> select T.branchname
> from branch as T
> where T.branchname="city";
>
> Do Oracle support using "as"? Or do I have any method
> to use it like the function "as"?
> Thanks.
>
> --
> regards,
> Ken
>
>
Received on Sat Nov 21 1998 - 03:02:35 CET

Original text of this message