OraFAQ Forum: SQL & PL/SQL » Can I assign an alias for a group of columns?

Home » SQL & PL/SQL » SQL & PL/SQL » Can I assign an alias for a group of columns?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can I assign an alias for a group of columns? [message #18665]

Sun, 10 February 2002 06:26

seewhy
Messages: 1
Registered: February 2002

Junior Member

Hi!
I am just wondering whether it is possible if assign an alias for multiple columns. For example, can I say:
Select (column1, column2) as alias from table 1.
then use the alias to link other tables?
Thank you very much!

Sincerely,
seewhy

Report message to a moderator

Re: Can I assign an alias for a group of columns? [message #18683 is a reply to message #18665]

Mon, 11 February 2002 02:06

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

hi,

it is not possible.you can do like this

Select column1 alas1, column2 alias2 from table 1.

cheers
pratap

Report message to a moderator

Previous Topic:	select statement
Next Topic:	How to select "last but one row" from a table?????

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 24 09:38:47 CDT 2025