I want to get only year using sysdate with my defined column name. but not able to get it.
SQL> select to_char(sysdate, 'yyyy') as "mahesh tyagi" from dual;
mahe
----
2015
SQL> select to_char(sysdate,'yy') as "mahesh" from dual;
ma
--
15
So i not able to get 'mahesh' or 'mahesh tyagi' as the column name.