Re: column alias

From: Frank <franjoe_at_frisurf.no>
Date: Tue, 20 Nov 2001 20:53:30 +0100
Message-ID: <vzyK7.773$Yn3.14344@news1.oke.nextra.no>

Hi!

At least this should work. Also look up the "as" keyword if you use Oracle8i ++

SELECT c1 column1,

               c1 col1,
               c1 column_1

FROM ........ Frank

kshathrya <kshathrya_at_hotmail.com> wrote in message news:tvlbng62jd5aec_at_corp.supernews.com...
> Hi,
> I would like to know whether I can have more column alias or
> descriotors for individual columns. For example, can i call the column c1
as
> colum1 and col1 and column_1 and so on. In other words i want to know
whther
> i can have more names for single columns in tables? Please advice, its
very
> ungent.
> thanks
> ks
>
>
>
>
Received on Tue Nov 20 2001 - 13:53:30 CST