Using reserved word "MODE" in select queries

From: Tinku <anbharga_at_cisco.com>
Date: 4 Mar 2004 21:45:51 -0800
Message-ID: <c47f56ca.0403042145.25197802@posting.google.com>

Hi All

We are migrating one of our application from Informix to Oracle.

Now one of our tables contains a column named "MODE" which is a reserved word. I could create the table with this name but double quoting the MODE, However when I try to do a select query it fails with error 936.

We would like to keep this column name unchanged as there are tons of other applications which access this table and this column. So if change the name we would have to make the change ALL OVER the place, which we want to avoid.

So now is it possible to be able to do select queries without changing the name of the column??

Thanks
Ankur Received on Thu Mar 04 2004 - 23:45:51 CST