Oracle PL/SQL/System Tables Views/USER TAB COMMENTS

View comment on any tables

SQL> -- View comment on any tables
SQL>
SQL> SELECT * FROM USER_TAB_COMMENTS where rownum < 50;
TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
SYSTEM_PRIVILEGE_MAP           TABLE
Description table for privilege type codes.  Maps privilege  type numbers to type names
TABLE_PRIVILEGE_MAP            TABLE
Description table for privilege (auditing option) type codes.  Maps privilege (auditing option) type numbers to type names
STMT_AUDIT_OPTION_MAP          TABLE
Description table for auditing option type codes.  Maps auditing option type numbers to type names

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
RESOURCE_MAP                   TABLE
Description table for resources.  Maps resource name to number
ATEMPTAB$                      TABLE
Temporary table whose definition is used internally.  Never contains data
SESSION_PRIVS                  VIEW
Privileges which the user currently has set

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
SESSION_ROLES                  VIEW
Roles which the user currently has enabled.
ROLE_SYS_PRIVS                 VIEW
System privileges granted to roles
ROLE_TAB_PRIVS                 VIEW
Table privileges granted to roles

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
ROLE_ROLE_PRIVS                VIEW
Roles which are granted to roles
DBA_ROLES                      VIEW
All Roles which exist in the database
DBA_PROFILES                   VIEW
Display all profiles and their limits

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
USER_RESOURCE_LIMITS           VIEW
Display resource limit of the user
USER_PASSWORD_LIMITS           VIEW
Display password limits of the user
RESOURCE_COST                  VIEW
Cost for each resource

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
USER_CATALOG                   VIEW
Tables, Views, Synonyms and Sequences owned by the user
ALL_CATALOG                    VIEW
All tables, views, synonyms, sequences accessible to the user
DBA_CATALOG                    VIEW
All database Tables, Views, Synonyms, Sequences

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
USER_CLUSTERS                  VIEW
Descriptions of user"s own clusters
ALL_CLUSTERS                   VIEW
Description of clusters accessible to the user
DBA_CLUSTERS                   VIEW
Description of all clusters in the database

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
USER_CLU_COLUMNS               VIEW
Mapping of table columns to cluster columns
DBA_CLU_COLUMNS                VIEW
Mapping of table columns to cluster columns
USER_COL_COMMENTS              VIEW
Comments on columns of user"s tables and views

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
ALL_COL_COMMENTS               VIEW
Comments on columns of accessible tables and views
DBA_COL_COMMENTS               VIEW
Comments on columns of all tables and views
USER_COL_PRIVS                 VIEW
Grants on columns for which the user is the owner, grantor or grantee

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
ALL_COL_PRIVS                  VIEW
Grants on columns for which the user is the grantor, grantee, owner,
 or an enabled role or PUBLIC is the grantee
DBA_COL_PRIVS                  VIEW
All grants on columns in the database
USER_COL_PRIVS_MADE            VIEW
All grants on columns of objects owned by the user
TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
ALL_COL_PRIVS_MADE             VIEW
Grants on columns for which the user is owner or grantor
USER_COL_PRIVS_RECD            VIEW
Grants on columns for which the user is the grantee
ALL_COL_PRIVS_RECD             VIEW
Grants on columns for which the user, PUBLIC or enabled role is the grantee
TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
DBA_ENCRYPTED_COLUMNS          VIEW
Encryption information on columns in the database
ALL_ENCRYPTED_COLUMNS          VIEW
Encryption information on all accessible columns
USER_ENCRYPTED_COLUMNS         VIEW
Encryption information on columns of tables owned by the user
TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
USER_DB_LINKS                  VIEW
Database links owned by the user
ALL_DB_LINKS                   VIEW
Database links accessible to the user
DBA_DB_LINKS                   VIEW
All database links in the database
TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
DICTIONARY                     VIEW
Description of data dictionary tables and views
DICT_COLUMNS                   VIEW
Description of columns in data dictionary tables and views
DBA_EXP_OBJECTS                VIEW
Objects that have been incrementally exported
TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
DBA_EXP_VERSION                VIEW
Version number of the last export session
DBA_EXP_FILES                  VIEW
Description of export files
USER_INDEXES                   VIEW
Description of the user"s own indexes
TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
ALL_INDEXES                    VIEW
Descriptions of indexes on tables accessible to the user
DBA_INDEXES                    VIEW
Description for all indexes in the database
USER_IND_COLUMNS               VIEW
COLUMNs comprising user"s INDEXes and INDEXes on user"s TABLES
TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
COMMENTS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
ALL_IND_COLUMNS                VIEW
COLUMNs comprising INDEXes on accessible TABLES

49 rows selected.
SQL>