The Oracle data dictionary contains a view that lists all Oracle data dictionary views, with a short description of their contents.
This view is called DICTIONARY; DICT is a shorter synonym for the same view.
The following table shows an abbreviated version of the query results. The DICT view contains more than 3000 rows!
select * from dict order by table_name; TABLE_NAME COMMENTS -------------------- ---------------------------------------- ALL_ALL_TABLES Description of all object and relational tables accessible to the user ALL_APPLY Details about each apply process that dequeues from the queue visible to the current user ... USER_COL_COMMENTS Comments on columns of user's tables and views USER_COL_PRIVS Grants on columns for which the user is the owner, grantor or grantee ... V$TIMEZONE_NAMES Synonym for V_$TIMEZONE_NAMES V$VERSION Synonym for V_$VERSION