Recently, I came across the view v$reserved_words. I wanted to know more about this view, so I did a little research and the result was the following list of questions and answers.

What information does v$reserved_words give?

Up to Oracle database version 10g Release 1 (10.1), the definition of this view was:

This view gives a […]

The V$, V_$, GV$ and GV_$ views are known as the ‘dynamic performance tables’ (DPT). They are called this because they have no physical existence in the database and are constantly changing (hence “dynamic”) views of the database system. Each time one of these views is accessed, it provides a snapshot for that moment in […]