-
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;
SYSDATE
---------
13-MAY-02
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 ?
Shiva.
-
SQL> select to_char(sysdate, 'dd-mon-rr') from dual;
TO_CHAR(S
---------
13-may-02
SQL> select to_char(sysdate, 'dd-Mon-rr') from dual;
TO_CHAR(S
---------
13-May-02
-
Code:
SQL> select to_char(sysdate,'mm/dd/yyy') "sYsDaTe" from dual;
sYsDaTe
---------
05/13/002
SQL>
-