Re: multiple column names

Not sure what you mean.
Do you mean:
create table mytab(
col1 varchar2(10),
col2 varchar2(20),...
)

Then you can say
select col1 as column_1, col2 as column_2 from mytab; or
select col1 as column_1, col2 as column_2, col1 as another_1, col2 as yet_another from mytab;

and in another select statement say:
select col1 as the_first_col,....

Please give an example of what you want to do, it isn't clear to me.

Jim

but you can't have 2 names for the first column "kshathrya" <kshathrya_at_hotmail.com> wrote in message news:tvlbmogia88qe5_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 - 14:15:18 CST