View comment on any tables : USER_TAB_COMMENTS « System Tables Views « Oracle PL / SQL






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>

           
       








Related examples in the same category