get a complete list of all the data dictionary views : dict « System Tables Views « Oracle PL / SQL






get a complete list of all the data dictionary views

 
SQL>
SQL> select * from dict
  2  where rownum < 50;

TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------
ALL_XML_SCHEMAS
Description of all XML Schemas that user has privi
lege to reference

ALL_XML_SCHEMAS2
Dummy version of ALL_XML_SCHEMAS that does not hav
e 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 granto
r, 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 g
rantor

USER_COL_PRIVS_RECD
Grants on columns for which the user is the grante
e

ALL_COL_PRIVS_RECD
Grants on columns for which the user, PUBLIC or en
abled 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


TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------
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 th
e user

DBA_INDEXES
Description for all indexes in the database

USER_IND_COLUMNS
COLUMNs comprising user's INDEXes and INDEXes on u
ser's TABLES

ALL_IND_COLUMNS
COLUMNs comprising INDEXes on accessible TABLES

DBA_IND_COLUMNS
COLUMNs comprising INDEXes on all TABLEs and CLUST
ERs

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

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

 








Related examples in the same category