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

Home -> Community -> Usenet -> c.d.o.server -> Re: column alias

Re: column alias

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Wed, 21 Nov 2001 04:53:37 GMT
Message-ID: <lrGK7.32507$xS6.55291@www.newsranger.com>


Hi,
AFAIK it's not possible. You can look at syntax diagram for SELECT statement. The possible workaroud is to select the same column several times with different aliases.

In article <tvlbng62jd5aec_at_corp.supernews.com>, kshathrya says...
>
> 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

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com
Received on Tue Nov 20 2001 - 22:53:37 CST

Original text of this message

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