Re: reserved words

steve wrote:

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

Once you use a reserved keyword in your day-to-day operations, you are forever stuck with using the escape sequence (quoting) and someone, possibly your successor, will be forever cursing the decision as they and others will forget to escape the keyword.

Besides, 'USER' is only useful for a few days. Then someone changes the specs and says 'this kind of user' and you need to add a new column 'USER2'. So why not switch to 'USER1' or 'LOGON_USER' or something else now?

Sadly, VOX (Voice Of eXperience) Received on Wed Jul 23 2003 - 21:36:20 CDT