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
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