select query to select a column named NUMBER
Hi all,
I have a table which is having a COLUMN NAME as NUMBER whose DATA TYPE is VARCHAR2(90 BYTE).
How should I select the column named NUMBER.
I am trying the sql query through SQL Developer.
I tried with following options.
1) select NUMBER from table_name
2) select [NUMBER] from table_name
3) select "NUMBER" from table_name
4) select [table_name.NUMBER] from table_name
But i did'nt succeed through the above queries. all the above queries are giving error.
So, please help me in this regard to query the column named NUMBER (which is a reserved word in Oracle)