Re: reserved words

The advice is right on spot.
Though Oracle also has a way to escape it by using mytable."USER" as in:
select "USER" from mytable;
delete from mytable where "USER" = 10;
...

However, its never a good idea to name objects which are on the reserved list.

Anurag

"steve" <asd_at_abc.com> wrote in message news:vhtu1gsr44b4a2_at_corp.supernews.com...
> thanks for the link...i can use quotes to reference it.
>
> however, the advice to use a more_sensible_name assumes that a susinct name
> is less sensible than
> a_longer_more_drawn_out_descriptive_that_only_exists_because_oracle_doesn't_
> work_well_without_it.
>
> ;^)
>
>
> "Andy Hassall" <andy_at_andyh.co.uk> wrote in message
> news:k4tthvgc35kr9vpedo0dnhm9ml65pb6v0i_at_4ax.com...
> > 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)
>
>
Received on Wed Jul 23 2003 - 18:28:58 CDT