Re: Using reserved word "MODE" in select queries

Tinku wrote:
> 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

Did you try with quotes in the select statement, too? If so - not possible, change the column name

-- 

Regards,
Frank van Bortel