Database - RAC/Scalability (MOSC)

MOSC Banner

Why are these words reserved in V$RESERVED_WORDS, when the columns indicate they are not?

edited Feb 2, 2016 4:02AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

Hello,

In Oracle 12 documentation writes the following about the view V$RESERVED_WORDS :

"V$RESERVED_WORDS displays a list of all SQL keywords. To determine whether a particular keyword is reserved in any way, check the RESERVED, RES_TYPE, RES_ATTR, and RES_SEMI columns."

But there are words in this view where all columns values for columns are RESERVED, RES_TYPE, RES_ATTR, and RES_SEMI are all "N".

ex:

select * from v$reserved_words

where RESERVED = 'N'

and RES_TYPE ='N'

and RES_ATTR = 'N'

and RES_SEMI = 'N'

order by 1,2

KEYWORD                            LENGTH RESE RES_ RES_ RES_ DUPL     CON_ID

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center