refer to the reply to forbrich...and maybe you'll have a better
understanding of why you should never say NEVER. ;^)
"Anurag Varma" <avdbi_at_hotmail.com> wrote in message
news:_SETa.4596$lm3.1488_at_news02.roc.ny...
> 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 - 22:19:23 CDT
