Reserved Words – Oracle

A quick post on how to check if a word is reserved using the v$reserved_words:

SELECT * FROM v$reserved_words WHERE reserved = 'Y'

Alernatively you can specify the word, i.e. to check if online is a reserved word, run the following:

SELECT *
FROM v$reserved_words
WHERE UPPER(keyword) LIKE '%ONLINE%'