Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed-east.nntpserver.com!nntpserver.com!priapus.visi.com!orange.octanews.net!news.octanews.net!news-out.visi.com!hermes.visi.com!news-out.octanews.net!news.state.mn.us!not-for-mail From: Turkbear Newsgroups: comp.databases.oracle.misc Subject: Re: The reserved word "ACCESS" in a field list of a PL SQL Query Date: Thu, 09 Sep 2004 08:45:09 -0500 Organization: Minnesota Governmental/Educational Agencies Lines: 31 Message-ID: References: <719532c5.0409080702.7a5ec43c@posting.google.com> Reply-To: johng@mm.nospam.com NNTP-Posting-Host: gateway.dot.state.mn.us Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news.state.mn.us 1094737509 913 156.98.4.11 (9 Sep 2004 13:45:09 GMT) X-Complaints-To: news@news.state.mn.us NNTP-Posting-Date: Thu, 9 Sep 2004 13:45:09 +0000 (UTC) X-Newsreader: Forte Agent 2.0/32.646 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:112546 Hans Forbrich wrote: >Lee wrote: > >> 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). > >Use of terms such as 'field' when you mean 'column' imply that you have very >limited experience with serious databases such as Oracle. > // Snipped rest Actually I was taught that a table has records which have fields and that they only are called rows and columns because of the way they are most often displayed, since they obviously are not arranged that way in the database. Tuples, anyone? ;-)