Re: SQL about "as"

Alternatively this can be used as well (Without using AS )

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

Thanks
Ashok

Madhu Cherukuri wrote:

> AS is used to represent a column alias.
> 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 Mon Nov 23 1998 - 16:30:34 CET