rename a column in query
525458Jun 12 2007 — edited Jun 12 2007Hello,
I want to rename a column in a query. What are the possible method?
1. We use "AS" to rename.
E.g.
SQL> select sysdate as "Today's date" from dual;
Today's d
---------
12-JUN-07
The above query returns "Today's Date". But the column name in the result set is not colplete "Today's Date" Why?
Thanks.