Home
Home
Help
Help
Contact us
Contact Us

Catalog Views / Data Dictionary Views

The data dictionary views, also known as catalog views, let you monitor the state of the database in real time:

Shortcuts to View Names

If you know the name of the view you want, select its abbreviation. Otherwise, scroll down to see the entire list.

List of Data Dictionary Views (A-Z)

ALL_ALL_TABLES: Syntax
ALL_APPLY: Syntax
ALL_APPLY_CONFLICT_COLUMNS: Syntax
ALL_APPLY_DML_HANDLERS: Syntax
ALL_APPLY_ENQUEUE: Syntax
ALL_APPLY_ERROR: Syntax
ALL_APPLY_EXECUTE: Syntax
ALL_APPLY_KEY_COLUMNS: Syntax
ALL_APPLY_PARAMETERS: Syntax
ALL_APPLY_PROGRESS: Syntax
ALL_APPLY_TABLE_COLUMNS: Syntax
ALL_ARGUMENTS: Syntax
ALL_ASSOCIATIONS: Syntax
ALL_AUDIT_POLICIES: Syntax
ALL_AUDIT_POLICY_COLUMNS: Syntax
ALL_AWS: Syntax
ALL_AW_PS: Syntax
ALL_BASE_TABLE_MVIEWS: Syntax
ALL_CAPTURE: Syntax
ALL_CAPTURE_EXTRA_ATTRIBUTES: Syntax
ALL_CAPTURE_PARAMETERS: Syntax
ALL_CAPTURE_PREPARED_DATABASE: Syntax
ALL_CAPTURE_PREPARED_SCHEMAS: Syntax
ALL_CAPTURE_PREPARED_TABLES: Syntax
ALL_CATALOG: Syntax
ALL_CLUSTERS: Syntax
ALL_CLUSTER_HASH_EXPRESSIONS: Syntax
ALL_COLL_TYPES: Syntax
ALL_COL_COMMENTS: Syntax
ALL_COL_PRIVS: Syntax
ALL_COL_PRIVS_MADE: Syntax
ALL_COL_PRIVS_RECD: Syntax
ALL_CONSTRAINTS: Syntax
ALL_CONS_COLUMNS: Syntax
ALL_CONS_OBJ_COLUMNS: Syntax
ALL_CONTEXT: Syntax
ALL_DB_LINKS: Syntax
ALL_DEF_AUDIT_OPTS: Syntax
ALL_DEPENDENCIES: Syntax
ALL_DEQUEUE_QUEUES: Syntax
ALL_DIMENSIONS: Syntax
ALL_DIM_ATTRIBUTES: Syntax
ALL_DIM_CHILD_OF: Syntax
ALL_DIM_HIERARCHIES: Syntax
ALL_DIM_JOIN_KEY: Syntax
ALL_DIM_LEVELS: Syntax
ALL_DIM_LEVEL_KEY: Syntax
ALL_DIRECTORIES: Syntax
ALL_ENCRYPTED_COLUMNS: Syntax
ALL_ERRORS: Syntax
ALL_EVALUATION_CONTEXTS: Syntax
ALL_EVALUATION_CONTEXT_TABLES: Syntax
ALL_EVALUATION_CONTEXT_VARS: Syntax
ALL_EXTERNAL_LOCATIONS: Syntax
ALL_EXTERNAL_TABLES: Syntax
ALL_FILE_GROUPS: Syntax
ALL_FILE_GROUP_EXPORT_INFO: Syntax
ALL_FILE_GROUP_FILES: Syntax
ALL_FILE_GROUP_TABLES: Syntax
ALL_FILE_GROUP_TABLESPACES: Syntax
ALL_FILE_GROUP_VERSIONS: Syntax
ALL_INDEXES: Syntax
ALL_INDEXTYPES: Syntax
ALL_INDEXTYPE_ARRAYTYPES: Syntax
ALL_INDEXTYPE_COMMENTS: Syntax
ALL_INDEXTYPE_OPERATORS: Syntax
ALL_IND_COLUMNS: Syntax
ALL_IND_EXPRESSIONS: Syntax
ALL_IND_PARTITIONS: Syntax
ALL_IND_STATISTICS: Syntax
ALL_IND_SUBPARTITIONS: Syntax
ALL_INTERNAL_TRIGGERS: Syntax
ALL_JAVA_ARGUMENTS: Syntax
ALL_JAVA_CLASSES: Syntax
ALL_JAVA_DERIVATIONS: Syntax
ALL_JAVA_FIELDS: Syntax
ALL_JAVA_IMPLEMENTS: Syntax
ALL_JAVA_INNERS: Syntax
ALL_JAVA_LAYOUTS: Syntax
ALL_JAVA_METHODS: Syntax
ALL_JAVA_NCOMPS: Syntax
ALL_JAVA_RESOLVERS: Syntax
ALL_JAVA_THROWS: Syntax
ALL_JOBS: Syntax
ALL_JOIN_IND_COLUMNS: Syntax
ALL_LIBRARIES: Syntax
ALL_LOBS: Syntax
ALL_LOB_PARTITIONS: Syntax
ALL_LOB_SUBPARTITIONS: Syntax
ALL_LOB_TEMPLATES: Syntax
ALL_LOG_GROUPS: Syntax
ALL_LOG_GROUP_COLUMNS: Syntax
ALL_METHOD_PARAMS: Syntax
ALL_METHOD_RESULTS: Syntax
ALL_MVIEWS: Syntax
ALL_MVIEW_AGGREGATES: Syntax
ALL_MVIEW_ANALYSIS: Syntax
ALL_MVIEW_COMMENTS: Syntax
ALL_MVIEW_DETAIL_RELATIONS: Syntax
ALL_MVIEW_JOINS: Syntax
ALL_MVIEW_KEYS: Syntax
ALL_MVIEW_LOGS: Syntax
ALL_MVIEW_REFRESH_TIMES: Syntax
ALL_NESTED_TABLES: Syntax
ALL_NESTED_TABLE_COLS: Syntax
ALL_OBJECTS: Syntax
ALL_OBJECT_TABLES: Syntax
ALL_OBJ_COLATTRS: Syntax
ALL_OPANCILLARY: Syntax
ALL_OPARGUMENTS: Syntax
ALL_OPBINDINGS: Syntax
ALL_OPERATORS: Syntax
ALL_OPERATOR_COMMENTS: Syntax
ALL_OUTLINES: Syntax
ALL_OUTLINE_HINTS: Syntax
ALL_PARTIAL_DROP_TABS: Syntax
ALL_PART_COL_STATISTICS: Syntax
ALL_PART_HISTOGRAMS: Syntax
ALL_PART_INDEXES: Syntax
ALL_PART_KEY_COLUMNS: Syntax
ALL_PART_LOBS: Syntax
ALL_PART_TABLES: Syntax
ALL_PENDING_CONV_TABLES: Syntax
ALL_PLSQL_OBJECT_SETTINGS: Syntax
ALL_POLICIES: Syntax
ALL_POLICY_CONTEXTS: Syntax
ALL_POLICY_GROUPS: Syntax
ALL_PROCEDURES: Syntax
ALL_PROPAGATION: Syntax
ALL_PUBLISHED_COLUMNS: Syntax
ALL_QUEUES: Syntax
ALL_QUEUE_SUBSCRIBERS: Syntax
ALL_QUEUE_TABLES: Syntax
ALL_REFRESH: Syntax
ALL_REFRESH_CHILDREN: Syntax
ALL_REFRESH_DEPENDENCIES: Syntax
ALL_REFS: Syntax
ALL_REGISTERED_MVIEWS: Syntax
ALL_REGISTRY_BANNERS: Syntax
ALL_REWRITE_EQUIVALENCES: Syntax
ALL_RULES: Syntax
ALL_RULE_SETS: Syntax
ALL_RULE_SET_RULES: Syntax
ALL_SCHEDULER_CHAINS: Syntax
ALL_SCHEDULER_CHAIN_RULES: Syntax
ALL_SCHEDULER_CHAIN_STEPS: Syntax
ALL_SCHEDULER_GLOBAL_ATTRIBUTE: Syntax
ALL_SCHEDULER_JOBS: Syntax
ALL_SCHEDULER_JOB_ARGS: Syntax
ALL_SCHEDULER_JOB_CLASSES: Syntax
ALL_SCHEDULER_JOB_LOG: Syntax
ALL_SCHEDULER_JOB_RUN_DETAILS: Syntax
ALL_SCHEDULER_PROGRAMS: Syntax
ALL_SCHEDULER_PROGRAM_ARGS: Syntax
ALL_SCHEDULER_RUNNING_CHAINS: Syntax
ALL_SCHEDULER_RUNNING_JOBS: Syntax
ALL_SCHEDULER_SCHEDULES: Syntax
ALL_SCHEDULER_WINDOWS: Syntax
ALL_SCHEDULER_WINDOW_DETAILS: Syntax
ALL_SCHEDULER_WINDOW_GROUPS: Syntax
ALL_SCHEDULER_WINDOW_LOG: Syntax
ALL_SCHEDULER_WINGROUP_MEMBERS: Syntax
ALL_SEC_RELEVANT_COLS: Syntax
ALL_SEQUENCES: Syntax
ALL_SERVICES: Syntax
ALL_SOURCE: Syntax
ALL_SOURCE_TABLES: Syntax
ALL_SQLJ_TYPES: Syntax
ALL_SQLJ_TYPE_ATTRS: Syntax
ALL_SQLJ_TYPE_METHODS: Syntax
ALL_SQLSET: Syntax
ALL_SQLSET_BINDS: Syntax
ALL_SQLSET_PLANS: Syntax
ALL_SQLSET_REFERENCES: Syntax
ALL_SQLSET_STATEMENTS: Syntax
ALL_STORED_SETTINGS: Syntax
ALL_STREAMS_GLOBAL_RULES: Syntax
ALL_STREAMS_MESSAGE_CONSUMERS: Syntax
ALL_STREAMS_MESSAGE_RULES: Syntax
ALL_STREAMS_NEWLY_SUPPORTED: Syntax
ALL_STREAMS_RULES: Syntax
ALL_STREAMS_SCHEMA_RULES: Syntax
ALL_STREAMS_TABLE_RULES: Syntax
ALL_STREAMS_TRANSFORM_FUNCTION: Syntax
ALL_STREAMS_UNSUPPORTED: Syntax
ALL_SUBPARTITION_TEMPLATES: Syntax
ALL_SUBPART_COL_STATISTICS: Syntax
ALL_SUBPART_HISTOGRAMS: Syntax
ALL_SUBPART_KEY_COLUMNS: Syntax
ALL_SUBSCRIBED_COLUMNS: Syntax
ALL_SUBSCRIBED_TABLES: Syntax
ALL_SUBSCRIPTIONS: Syntax
ALL_SUMDELTA: Syntax
ALL_SYNONYMS: Syntax
ALL_TABLES: Syntax
ALL_TAB_COLS: Syntax
ALL_TAB_COLUMNS: Syntax
ALL_TAB_COL_STATISTICS: Syntax
ALL_TAB_COMMENTS: Syntax
ALL_TAB_HISTOGRAMS: Syntax
ALL_TAB_MODIFICATIONS: Syntax
ALL_TAB_PARTITIONS: Syntax
ALL_TAB_PRIVS: Syntax
ALL_TAB_PRIVS_MADE: Syntax
ALL_TAB_PRIVS_RECD: Syntax
ALL_TAB_STATISTICS: Syntax
ALL_TAB_STATS_HISTORY: Syntax
ALL_TAB_SUBPARTITIONS: Syntax
ALL_TRIGGERS: Syntax
ALL_TRIGGER_COLS: Syntax
ALL_TYPES: Syntax
ALL_TYPE_ATTRS: Syntax
ALL_TYPE_METHODS: Syntax
ALL_TYPE_VERSIONS: Syntax
ALL_UNUSED_COL_TABS: Syntax
ALL_UPDATABLE_COLUMNS: Syntax
ALL_USERS: Syntax
ALL_USTATS: Syntax
ALL_VARRAYS: Syntax
ALL_VIEWS: Syntax
ALL_WARNING_SETTINGS: Syntax
ALL_XML_SCHEMAS: Syntax
ALL_XML_TABLES: Syntax
ALL_XML_TAB_COLS: Syntax
ALL_XML_VIEWS: Syntax
ALL_XML_VIEW_COLS: Syntax