Re: reserved words

From: steve <asd_at_abc.com>
Date: Wed, 23 Jul 2003 16:03:44 -0500
Message-ID: <vhtu1gsr44b4a2@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 - 16:03:44 CDT