By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,504 Members | 1,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,504 IT Pros & Developers. It's quick & easy.

Using reserved word "MODE" in select queries

P: n/a
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
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.