To_Char function in Oracle ,giving an error for alias?

Question

This is the command,i am using in ORACLE 9i.

SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY') Date FROM DUAL;

It gives an error "FROM keyword not found,Expected" ,where Date is an ALIAS,but when i enclosed Date in "Date" double quotes like this ,it is taking it as an Alias and output is right.

Please SUGGEST!!!

Answer 1

Probably caused because Date is a reserved word in Oracle,

SELECT *
FROM v$reserved_words
where keyword = 'DATE'

Putting the '' around it "escapes" it so it can be used.