http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2FdictOracle PL/SQL/System Tables Views/dict - История изменений2026-05-25T13:01:39ZИстория изменений этой страницы в викиMediaWiki 1.30.0http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/dict&diff=2402&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://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/dict&diff=2403&oldid=prevAdmin: 1 версия2010-05-26T10:01:27Z<p>1 версия</p>
<p><b>Новая страница</b></p><div>==get a complete list of all the data dictionary views==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> select * from dict<br />
2 where rownum < 50;<br />
TABLE_NAME<br />
------------------------------<br />
COMMENTS<br />
--------------------------------------------------<br />
ALL_XML_SCHEMAS<br />
Description of all XML Schemas that user has privi<br />
lege to reference<br />
ALL_XML_SCHEMAS2<br />
Dummy version of ALL_XML_SCHEMAS that does not hav<br />
e an XMLTYPE column<br />
DBA_ROLES<br />
All Roles which exist in the database<br />
DBA_PROFILES<br />
Display all profiles and their limits<br />
USER_RESOURCE_LIMITS<br />
Display resource limit of the user<br />
USER_PASSWORD_LIMITS<br />
Display password limits of the user<br />
USER_CATALOG<br />
Tables, Views, Synonyms and Sequences owned by the<br />
user<br />
ALL_CATALOG<br />
All tables, views, synonyms, sequences accessible<br />
to the user<br />
DBA_CATALOG<br />
All database Tables, Views, Synonyms, Sequences<br />
USER_CLUSTERS<br />
Descriptions of user"s own clusters<br />
ALL_CLUSTERS<br />
Description of clusters accessible to the user<br />
DBA_CLUSTERS<br />
Description of all clusters in the database<br />
USER_CLU_COLUMNS<br />
Mapping of table columns to cluster columns<br />
DBA_CLU_COLUMNS<br />
Mapping of table columns to cluster columns<br />
USER_COL_COMMENTS<br />
Comments on columns of user"s tables and views<br />
ALL_COL_COMMENTS<br />
Comments on columns of accessible tables and views<br />
DBA_COL_COMMENTS<br />
Comments on columns of all tables and views<br />
USER_COL_PRIVS<br />
Grants on columns for which the user is the owner,<br />
grantor or grantee<br />
ALL_COL_PRIVS<br />
Grants on columns for which the user is the granto<br />
r, grantee, owner,<br />
or an enabled role or PUBLIC is the grantee<br />
DBA_COL_PRIVS<br />
All grants on columns in the database<br />
USER_COL_PRIVS_MADE<br />
All grants on columns of objects owned by the user<br />
ALL_COL_PRIVS_MADE<br />
Grants on columns for which the user is owner or g<br />
rantor<br />
USER_COL_PRIVS_RECD<br />
Grants on columns for which the user is the grante<br />
e<br />
ALL_COL_PRIVS_RECD<br />
Grants on columns for which the user, PUBLIC or en<br />
abled role is the grantee<br />
DBA_ENCRYPTED_COLUMNS<br />
Encryption information on columns in the database<br />
ALL_ENCRYPTED_COLUMNS<br />
Encryption information on all accessible columns<br />
USER_ENCRYPTED_COLUMNS<br />
Encryption information on columns of tables owned<br />
by the user<br />
USER_DB_LINKS<br />
Database links owned by the user<br />
<br />
TABLE_NAME<br />
------------------------------<br />
COMMENTS<br />
--------------------------------------------------<br />
ALL_DB_LINKS<br />
Database links accessible to the user<br />
DBA_DB_LINKS<br />
All database links in the database<br />
DBA_EXP_OBJECTS<br />
Objects that have been incrementally exported<br />
DBA_EXP_VERSION<br />
Version number of the last export session<br />
DBA_EXP_FILES<br />
Description of export files<br />
USER_INDEXES<br />
Description of the user"s own indexes<br />
ALL_INDEXES<br />
Descriptions of indexes on tables accessible to th<br />
e user<br />
DBA_INDEXES<br />
Description for all indexes in the database<br />
USER_IND_COLUMNS<br />
COLUMNs comprising user"s INDEXes and INDEXes on u<br />
ser"s TABLES<br />
ALL_IND_COLUMNS<br />
COLUMNs comprising INDEXes on accessible TABLES<br />
DBA_IND_COLUMNS<br />
COLUMNs comprising INDEXes on all TABLEs and CLUST<br />
ERs<br />
USER_IND_EXPRESSIONS<br />
Functional index expressions in user"s indexes and<br />
indexes on user"s tables<br />
ALL_IND_EXPRESSIONS<br />
FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES<br />
DBA_IND_EXPRESSIONS<br />
FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLU<br />
STERS<br />
USER_JOIN_IND_COLUMNS<br />
Join Index columns comprising the join conditions<br />
ALL_JOIN_IND_COLUMNS<br />
Join Index columns comprising the join conditions<br />
DBA_JOIN_IND_COLUMNS<br />
Join Index columns comprising the join conditions<br />
USER_OBJECTS<br />
Objects owned by the user<br />
ALL_OBJECTS<br />
Objects accessible to the user<br />
DBA_OBJECTS<br />
All objects in the database<br />
USER_PROCEDURES<br />
Description of the users own procedures<br />
<br />
49 rows selected.<br />
SQL><br />
SQL><br />
SQL> --<br />
</source></div>Admin