Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Create View
Hi,
I am learning and would need your help.
I'm able to create a simple SQL in the oracle view.
Select Home
AS
HOME FROM CITYDATABASE
WHERE HOME = 'Single'
/
I want to know if there is a possilbe way to add extra column called "YEAR" like Format([Month_END],"YYYY" into above script.
Your help would be much appreciated.
Thanks
Received on Thu Aug 16 2007 - 08:48:24 CDT