в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T10:01:23Z

1 версия

Новая страница

==Query dictionary table==



<source lang="sql">

SQL>
SQL> set echo off
SQL> set verify off
SQL> set linesize 72
SQL> set pagesize 9999
SQL> set feedback on
SQL>
SQL> column table_name format a30
SQL> column comments format a200
SQL>
SQL>
SQL> select *
2 from dictionary
3 where rownum < 50
4 /
TABLE_NAME
------------------------------
Comments
------------------------------------------------------------------------
ALL_XML_SCHEMAS
Description of all XML Schemas that user has privilege to reference
ALL_XML_SCHEMAS2
Dummy version of ALL_XML_SCHEMAS that does not have an XMLTYPE column
DBA_ROLES
All Roles which exist in the database
DBA_PROFILES
Display all profiles and their limits
USER_RESOURCE_LIMITS
Display resource limit of the user
USER_PASSWORD_LIMITS
Display password limits of the user
USER_CATALOG
Tables, Views, Synonyms and Sequences owned by the user
ALL_CATALOG
All tables, views, synonyms, sequences accessible to the user
DBA_CATALOG
All database Tables, Views, Synonyms, Sequences
USER_CLUSTERS
Descriptions of user"s own clusters
ALL_CLUSTERS
Description of clusters accessible to the user
DBA_CLUSTERS
Description of all clusters in the database
USER_CLU_COLUMNS
Mapping of table columns to cluster columns
DBA_CLU_COLUMNS
Mapping of table columns to cluster columns
USER_COL_COMMENTS
Comments on columns of user"s tables and views
ALL_COL_COMMENTS
Comments on columns of accessible tables and views
DBA_COL_COMMENTS
Comments on columns of all tables and views
USER_COL_PRIVS
Grants on columns for which the user is the owner, grantor or grantee
ALL_COL_PRIVS
Grants on columns for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee
DBA_COL_PRIVS
All grants on columns in the database
USER_COL_PRIVS_MADE
All grants on columns of objects owned by the user
ALL_COL_PRIVS_MADE
Grants on columns for which the user is owner or grantor
USER_COL_PRIVS_RECD
Grants on columns for which the user is the grantee
ALL_COL_PRIVS_RECD
Grants on columns for which the user, PUBLIC or enabled role is the
grantee
DBA_ENCRYPTED_COLUMNS
Encryption information on columns in the database
ALL_ENCRYPTED_COLUMNS
Encryption information on all accessible columns
USER_ENCRYPTED_COLUMNS
Encryption information on columns of tables owned by the user
USER_DB_LINKS
Database links owned by the user
ALL_DB_LINKS
Database links accessible to the user
DBA_DB_LINKS
All database links in the database
DBA_EXP_OBJECTS
Objects that have been incrementally exported
DBA_EXP_VERSION
Version number of the last export session
DBA_EXP_FILES
Description of export files
USER_INDEXES
Description of the user"s own indexes
ALL_INDEXES
Descriptions of indexes on tables accessible to the user
DBA_INDEXES
Description for all indexes in the database
USER_IND_COLUMNS
COLUMNs comprising user"s INDEXes and INDEXes on user"s TABLES
ALL_IND_COLUMNS
COLUMNs comprising INDEXes on accessible TABLES
DBA_IND_COLUMNS
COLUMNs comprising INDEXes on all TABLEs and CLUSTERs
USER_IND_EXPRESSIONS
Functional index expressions in user"s indexes and indexes on user"s
tables
ALL_IND_EXPRESSIONS
FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES
DBA_IND_EXPRESSIONS
FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS
USER_JOIN_IND_COLUMNS
Join Index columns comprising the join conditions
ALL_JOIN_IND_COLUMNS
Join Index columns comprising the join conditions
DBA_JOIN_IND_COLUMNS
Join Index columns comprising the join conditions
USER_OBJECTS
Objects owned by the user
ALL_OBJECTS
Objects accessible to the user
DBA_OBJECTS
All objects in the database
USER_PROCEDURES
Description of the users own procedures

49 rows selected.
SQL>
SQL> --
</source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL/System Tables Views/dictionary - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия