Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How would I write this sql

Re: How would I write this sql

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Sat, 07 Jun 2003 03:03:21 GMT
Message-ID: <ZBcEa.42183$ca5.11120@nwrdny02.gnilink.net>


user is a reserved word in oracle .. try some other alias.

see v$reserved_words for the list of reserved words

Anurag
"Jake" <oracle-news_at_heyjay.com> wrote in message news:bbrj7t$599$1_at_bob.news.rcn.net...
> How can I write this sql?
>
> SQL> SELECT user.id
> 2 FROM organization user
> 3 WHERE userid = 'myname'
> 4 /
> SELECT user.id
> *
> ERROR at line 1:
> ORA-00923: FROM keyword not found where expected
>
> I'm not able to change the table alias. And I know the error is from
"user"
> being a pseudo column.
>
> but is there some sort of quoting, or something I could do, and leave the
> table alias?
>
> Thanks
> Jay
>
>
Received on Fri Jun 06 2003 - 22:03:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US