Hi all, just a curious question :
When retrieving the resultset from a SQL Query, is it possible to convert the case of the column heading displayed ? For
e.g., select sysdate from dual;
If I want to change the case of SYSDATE in the output,
I couldn't find a way to do it !! Is it really possible ?
SQL> select to_char(sysdate, 'dd-mon-rr') from dual;
SQL> select to_char(sysdate, 'dd-Mon-rr') from dual;
SQL> select to_char(sysdate,'mm/dd/yyy') "sYsDaTe" from dual;