http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2FUSER_TAB_COMMENTSOracle PL/SQL/System Tables Views/USER TAB COMMENTS - История изменений2026-05-24T21:42:31ZИстория изменений этой страницы в викиMediaWiki 1.30.0http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/USER_TAB_COMMENTS&diff=2404&oldid=prev в 13:45, 26 мая 20102010-05-26T13:45:19Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/USER_TAB_COMMENTS&diff=2405&oldid=prevAdmin: 1 версия2010-05-26T10:01:28Z<p>1 версия</p>
<p><b>Новая страница</b></p><div>==View comment on any tables==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> -- View comment on any tables<br />
SQL><br />
SQL> SELECT * FROM USER_TAB_COMMENTS where rownum < 50;<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
SYSTEM_PRIVILEGE_MAP TABLE<br />
Description table for privilege type codes. Maps privilege type numbers to type names<br />
TABLE_PRIVILEGE_MAP TABLE<br />
Description table for privilege (auditing option) type codes. Maps privilege (auditing option) type numbers to type names<br />
STMT_AUDIT_OPTION_MAP TABLE<br />
Description table for auditing option type codes. Maps auditing option type numbers to type names<br />
<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
RESOURCE_MAP TABLE<br />
Description table for resources. Maps resource name to number<br />
ATEMPTAB$ TABLE<br />
Temporary table whose definition is used internally. Never contains data<br />
SESSION_PRIVS VIEW<br />
Privileges which the user currently has set<br />
<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
SESSION_ROLES VIEW<br />
Roles which the user currently has enabled.<br />
ROLE_SYS_PRIVS VIEW<br />
System privileges granted to roles<br />
ROLE_TAB_PRIVS VIEW<br />
Table privileges granted to roles<br />
<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
ROLE_ROLE_PRIVS VIEW<br />
Roles which are granted to roles<br />
DBA_ROLES VIEW<br />
All Roles which exist in the database<br />
DBA_PROFILES VIEW<br />
Display all profiles and their limits<br />
<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
USER_RESOURCE_LIMITS VIEW<br />
Display resource limit of the user<br />
USER_PASSWORD_LIMITS VIEW<br />
Display password limits of the user<br />
RESOURCE_COST VIEW<br />
Cost for each resource<br />
<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
USER_CATALOG VIEW<br />
Tables, Views, Synonyms and Sequences owned by the user<br />
ALL_CATALOG VIEW<br />
All tables, views, synonyms, sequences accessible to the user<br />
DBA_CATALOG VIEW<br />
All database Tables, Views, Synonyms, Sequences<br />
<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
USER_CLUSTERS VIEW<br />
Descriptions of user"s own clusters<br />
ALL_CLUSTERS VIEW<br />
Description of clusters accessible to the user<br />
DBA_CLUSTERS VIEW<br />
Description of all clusters in the database<br />
<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
USER_CLU_COLUMNS VIEW<br />
Mapping of table columns to cluster columns<br />
DBA_CLU_COLUMNS VIEW<br />
Mapping of table columns to cluster columns<br />
USER_COL_COMMENTS VIEW<br />
Comments on columns of user"s tables and views<br />
<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
ALL_COL_COMMENTS VIEW<br />
Comments on columns of accessible tables and views<br />
DBA_COL_COMMENTS VIEW<br />
Comments on columns of all tables and views<br />
USER_COL_PRIVS VIEW<br />
Grants on columns for which the user is the owner, grantor or grantee<br />
<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
ALL_COL_PRIVS VIEW<br />
Grants on columns for which the user is the grantor, grantee, owner,<br />
or an enabled role or PUBLIC is the grantee<br />
DBA_COL_PRIVS VIEW<br />
All grants on columns in the database<br />
USER_COL_PRIVS_MADE VIEW<br />
All grants on columns of objects owned by the user<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
ALL_COL_PRIVS_MADE VIEW<br />
Grants on columns for which the user is owner or grantor<br />
USER_COL_PRIVS_RECD VIEW<br />
Grants on columns for which the user is the grantee<br />
ALL_COL_PRIVS_RECD VIEW<br />
Grants on columns for which the user, PUBLIC or enabled role is the grantee<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
DBA_ENCRYPTED_COLUMNS VIEW<br />
Encryption information on columns in the database<br />
ALL_ENCRYPTED_COLUMNS VIEW<br />
Encryption information on all accessible columns<br />
USER_ENCRYPTED_COLUMNS VIEW<br />
Encryption information on columns of tables owned by the user<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
USER_DB_LINKS VIEW<br />
Database links owned by the user<br />
ALL_DB_LINKS VIEW<br />
Database links accessible to the user<br />
DBA_DB_LINKS VIEW<br />
All database links in the database<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
DICTIONARY VIEW<br />
Description of data dictionary tables and views<br />
DICT_COLUMNS VIEW<br />
Description of columns in data dictionary tables and views<br />
DBA_EXP_OBJECTS VIEW<br />
Objects that have been incrementally exported<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
DBA_EXP_VERSION VIEW<br />
Version number of the last export session<br />
DBA_EXP_FILES VIEW<br />
Description of export files<br />
USER_INDEXES VIEW<br />
Description of the user"s own indexes<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
ALL_INDEXES VIEW<br />
Descriptions of indexes on tables accessible to the user<br />
DBA_INDEXES VIEW<br />
Description for all indexes in the database<br />
USER_IND_COLUMNS VIEW<br />
COLUMNs comprising user"s INDEXes and INDEXes on user"s TABLES<br />
TABLE_NAME TABLE_TYPE<br />
------------------------------ -----------<br />
COMMENTS<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------------------------<br />
ALL_IND_COLUMNS VIEW<br />
COLUMNs comprising INDEXes on accessible TABLES<br />
<br />
49 rows selected.<br />
SQL><br />
<br />
</source></div>Admin