Oracle PL/SQL/System Tables Views/dict
get a complete list of all the data dictionary views
<source lang="sql">
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> --
</source>