Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>