Re: reserved words

On Wed, 23 Jul 2003 15:11:59 -0500, "steve" <asd_at_abc.com> wrote:

>i'm looking for the oracle equivalent to referencing a column named USER...

alter table x rename column "USER" to more_sensible_name;

 ... springs to mind.

>in sql server you could escape it like mytable.[USER]
>
>is there a similar syntax in oracle?

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements9a.htm#27571

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)