ORA-0936 while select DATE as column name

 hi,

some one created table with "date" as column in it. Looks like they might have created that table using OEM or some other tool.

I know we can not use that key word as column/ object name using SQL*PLUS.  I am surprised why OEM even does not have such checks.

I am able to get the date when I do "select * from <table_name>".

I am getting the following error when I issue "select date from <table_name>" or "select * from <table_name> where date .... "

ERROR at line 1:
ORA-00936: missing expression

Please suggest me.