Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: column alias
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.comReceived on Tue Nov 20 2001 - 22:53:37 CST