Re: The reserved word "ACCESS" in a field list of a PL SQL Query

"Lee" <lduhl_at_corp.realcomp.com> a écrit dans le message de news:719532c5.0409080702.7a5ec43c_at_posting.google.com...
> We have a field in our tables call "ACCESS", but we are unable to
> reference this field in a query becuase it appears to be a reserved
> word in Oracle (we are running Oracle 10g on Windows 2k).
>
> A query like the following results in a "Ora-00936:Missing Expression"
> error message:
> SELECT Access FROM sys.MyTable.
>
> The Field "Access" is a valid field within the table "MyTable".
>
> Additionally, our application dynamically builds this query so any
> soluiton that includes "Aliasing" this field probably will not work.
>
> Is there anyway around quering this field in the table without
> re-naming the field in the table?
>
> Thanks for any info that can be provided.
> Lee

The only way i know is to use
select "ACCESS" from mytable;

Btw, you should not create tables in sys schema. SYS is Oracle's and nothing must be created in SYS schema.

-- 
Regards
Michel Cadot