Query dictionary table : dictionary « System Tables Views « Oracle PL / SQL






Query dictionary table

 
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> --

 








Related examples in the same category