Robbert van der Hoorn wrote:
> "DA Morgan" <damorgan_at_psoug.org> schreef in bericht
> news:1160152896.121354_at_bubbleator.drizzle.com...
>> It is generally a bad idea to name variables after reserved words.
>> --
>> Daniel Morgan
>> University of Washington
>> Puget Sound Oracle Users Group
>
> Daniel,
>
> about these reserved words: in the view GV$RESERVED_WORDS the keywords are
> listed with attributes like 'RESERVED'. What does it mean if a keyword is in
> the view with RESERVED='N' ? (a lot of them are...) And why do 708 Oracle
> tables and views (dba_tab_cols) have a column called 'NAME' if it is a
> reserved word? Looks like some words are more reserved than others...
>
> Note: I'm NOT stating that name is not a reserved word, for if we must
> believe this view, ' IF' isn't either....
> It's just that I have seen variables and columns with name 'NAME' so often,
> I even didn't realize it is a reserved word....
>
> Thanks in advance,
>
> Robbert
Can't answer your questions as I don't work for Oracle. What I can
say, though, is that it is asking for trouble to use any word here
to name an object or variable.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Oct 12 2006 - 16:12:00 CDT
