Re: How would I write this sql

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Sat, 7 Jun 2003 20:02:23 +1000
Message-ID: <3ee1bae4$0$15841$afc38c87@news.optusnet.com.au>

"Jake" <oracle-news_at_heyjay.com> wrote in message news:bbrj7t$599$1_at_bob.news.rcn.net...

>
> 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?
>

That is weird. You can't change the table alias but you can quote it?

Well anyways: any reserved word can be used in Oracle provided you lower-case it and use "(rabitt's ears) around.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Sat Jun 07 2003 - 05:02:23 CDT