First page Back Continue Last page Graphics

...DICTIONARY View


Notes:

Since finding data dictionary views is a frequent task, I keep a script handy that assists me. This script, shown above, searches the dictionary view for views that contain the string I provide as an argument.
For example, say I was interested in finding all DBA-level views related to privileges. I would enter:
SQL> @dict dba_%priv%

TABLE_NAME COMMENTS
------------------------- ------------------------------
DBA_SYS_PRIVS System privileges granted to
users and roles

DBA_TAB_PRIVS All grants on objects in the
database
This script (DICT.SQL) is available with your supplied scripts.