oracle column alias

From: <weixingchen_at_my-dejanews.com>
Date: Wed, 05 May 1999 19:57:57 GMT
Message-ID: <7gq7s1$5ap$1@nnrp1.deja.com>

Hi everyone,

I am trying to create a view with column name alias as the name of the current month, for example, a query of one such view will generate data like

column1 May

--- Dallas 54 St. Louis 30

It seems that I can't use to_char(sysdate, ...) function for column alias. Can anyone help with this.

Thanks in advance

Wayne

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed May 05 1999 - 14:57:57 CDT