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

From: Lee <lduhl_at_corp.realcomp.com>
Date: 8 Sep 2004 08:02:30 -0700
Message-ID: <719532c5.0409080702.7a5ec43c@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 Received on Wed Sep 08 2004 - 10:02:30 CDT