![]() Home |
![]() Help |
![]() Contact Us |
The data dictionary views, also known as catalog views, let you monitor the state of the database in real time:
If you know the name of the view you want, select its abbreviation. Otherwise, scroll down to see the entire list.
ALL |
ALL_ALL_TABLES: Syntax, Search for it |
ALL_APPLY: Syntax, Search for it |
ALL_APPLY_CHANGE_HANDLERS: Syntax, Search for it |
ALL_APPLY_CONFLICT_COLUMNS: Syntax, Search for it |
ALL_APPLY_DML_HANDLERS: Syntax, Search for it |
ALL_APPLY_ENQUEUE: Syntax, Search for it |
ALL_APPLY_ERROR: Syntax, Search for it |
ALL_APPLY_ERROR_MESSAGES: Syntax, Search for it |
ALL_APPLY_EXECUTE: Syntax, Search for it |
ALL_APPLY_KEY_COLUMNS: Syntax, Search for it |
ALL_APPLY_PARAMETERS: Syntax, Search for it |
ALL_APPLY_PROGRESS: Syntax, Search for it |
ALL_APPLY_TABLE_COLUMNS: Syntax, Search for it |
ALL_ARGUMENTS: Syntax, Search for it |
ALL_ASSEMBLIES: Syntax, Search for it |
ALL_ASSOCIATIONS: Syntax, Search for it |
ALL_ATTRIBUTE_TRANSFORMATIONS: Syntax, Search for it |
ALL_AUDIT_POLICIES: Syntax, Search for it |
ALL_AUDIT_POLICY_COLUMNS: Syntax, Search for it |
ALL_AW_PS: Syntax, Search for it |
ALL_AWS: Syntax, Search for it |
ALL_BASE_TABLE_MVIEWS: Syntax, Search for it |
ALL_CAPTURE: Syntax, Search for it |
ALL_CAPTURE_EXTRA_ATTRIBUTES: Syntax, Search for it |
ALL_CAPTURE_PARAMETERS: Syntax, Search for it |
ALL_CAPTURE_PREPARED_DATABASE: Syntax, Search for it |
ALL_CAPTURE_PREPARED_SCHEMAS: Syntax, Search for it |
ALL_CAPTURE_PREPARED_TABLES: Syntax, Search for it |
ALL_CATALOG: Syntax, Search for it |
ALL_CHANGE_PROPAGATION_SETS: Syntax, Search for it |
ALL_CHANGE_PROPAGATIONS: Syntax, Search for it |
ALL_CHANGE_SETS: Syntax, Search for it |
ALL_CHANGE_SOURCES: Syntax, Search for it |
ALL_CHANGE_TABLES: Syntax, Search for it |
ALL_CLUSTER_HASH_EXPRESSIONS: Syntax, Search for it |
ALL_CLUSTERS: Syntax, Search for it |
ALL_COL_COMMENTS: Syntax, Search for it |
ALL_COL_PENDING_STATS: Syntax, Search for it |
ALL_COL_PRIVS: Syntax, Search for it |
ALL_COL_PRIVS_MADE: Syntax, Search for it |
ALL_COL_PRIVS_RECD: Syntax, Search for it |
ALL_COLL_TYPES: Syntax, Search for it |
ALL_CONS_COLUMNS: Syntax, Search for it |
ALL_CONS_OBJ_COLUMNS: Syntax, Search for it |
ALL_CONSTRAINTS: Syntax, Search for it |
ALL_CONTEXT: Syntax, Search for it |
ALL_CUBE_ATTR_VISIBILITY: Syntax, Search for it |
ALL_CUBE_ATTRIBUTES: Syntax, Search for it |
ALL_CUBE_BUILD_PROCESSES: Syntax, Search for it |
ALL_CUBE_CALCULATED_MEMBERS: Syntax, Search for it |
ALL_CUBE_DIM_LEVELS: Syntax, Search for it |
ALL_CUBE_DIM_MODELS: Syntax, Search for it |
ALL_CUBE_DIM_VIEW_COLUMNS: Syntax, Search for it |
ALL_CUBE_DIM_VIEWS: Syntax, Search for it |
ALL_CUBE_DIMENSIONALITY: Syntax, Search for it |
ALL_CUBE_DIMENSIONS: Syntax, Search for it |
ALL_CUBE_HIER_LEVELS: Syntax, Search for it |
ALL_CUBE_HIER_VIEW_COLUMNS: Syntax, Search for it |
ALL_CUBE_HIER_VIEWS: Syntax, Search for it |
ALL_CUBE_HIERARCHIES: Syntax, Search for it |
ALL_CUBE_MEASURES: Syntax, Search for it |
ALL_CUBE_VIEW_COLUMNS: Syntax, Search for it |
ALL_CUBE_VIEWS: Syntax, Search for it |
ALL_CUBES: Syntax, Search for it |
ALL_DB_LINKS: Syntax, Search for it |
ALL_DEF_AUDIT_OPTS: Syntax, Search for it |
ALL_DEPENDENCIES: Syntax, Search for it |
ALL_DEQUEUE_QUEUES: Syntax, Search for it |
ALL_DIM_ATTRIBUTES: Syntax, Search for it |
ALL_DIM_CHILD_OF: Syntax, Search for it |
ALL_DIM_HIERARCHIES: Syntax, Search for it |
ALL_DIM_JOIN_KEY: Syntax, Search for it |
ALL_DIM_LEVEL_KEY: Syntax, Search for it |
ALL_DIM_LEVELS: Syntax, Search for it |
ALL_DIMENSIONS: Syntax, Search for it |
ALL_DIRECTORIES: Syntax, Search for it |
ALL_EDITION_COMMENTS: Syntax, Search for it |
ALL_EDITIONING_VIEW_COLS: Syntax, Search for it |
ALL_EDITIONING_VIEW_COLS_AE: Syntax, Search for it |
ALL_EDITIONING_VIEWS: Syntax, Search for it |
ALL_EDITIONING_VIEWS_AE: Syntax, Search for it |
ALL_EDITIONS: Syntax, Search for it |
ALL_ENCRYPTED_COLUMNS: Syntax, Search for it |
ALL_ERRORS: Syntax, Search for it |
ALL_ERRORS_AE: Syntax, Search for it |
ALL_EVALUATION_CONTEXT_TABLES: Syntax, Search for it |
ALL_EVALUATION_CONTEXT_VARS: Syntax, Search for it |
ALL_EVALUATION_CONTEXTS: Syntax, Search for it |
ALL_EXTERNAL_LOCATIONS: Syntax, Search for it |
ALL_EXTERNAL_TABLES: Syntax, Search for it |
ALL_FILE_GROUP_EXPORT_INFO: Syntax, Search for it |
ALL_FILE_GROUP_FILES: Syntax, Search for it |
ALL_FILE_GROUP_TABLES: Syntax, Search for it |
ALL_FILE_GROUP_TABLESPACES: Syntax, Search for it |
ALL_FILE_GROUP_VERSIONS: Syntax, Search for it |
ALL_FILE_GROUPS: Syntax, Search for it |
ALL_GG_INBOUND_PROGRESS: Syntax, Search for it |
ALL_GOLDENGATE_INBOUND: Syntax, Search for it |
ALL_HISTOGRAMS: Syntax, Search for it |
ALL_IDENTIFIERS: Syntax, Search for it |
ALL_IND_COLUMNS: Syntax, Search for it |
ALL_IND_EXPRESSIONS: Syntax, Search for it |
ALL_IND_PARTITIONS: Syntax, Search for it |
ALL_IND_PENDING_STATS: Syntax, Search for it |
ALL_IND_STATISTICS: Syntax, Search for it |
ALL_IND_SUBPARTITIONS: Syntax, Search for it |
ALL_INDEXES: Syntax, Search for it |
ALL_INDEXTYPE_ARRAYTYPES: Syntax, Search for it |
ALL_INDEXTYPE_COMMENTS: Syntax, Search for it |
ALL_INDEXTYPE_OPERATORS: Syntax, Search for it |
ALL_INDEXTYPES: Syntax, Search for it |
ALL_INTERNAL_TRIGGERS: Syntax, Search for it |
ALL_JAVA_ARGUMENTS: Syntax, Search for it |
ALL_JAVA_CLASSES: Syntax, Search for it |
ALL_JAVA_COMPILER_OPTIONS: Syntax, Search for it |
ALL_JAVA_DERIVATIONS: Syntax, Search for it |
ALL_JAVA_FIELDS: Syntax, Search for it |
ALL_JAVA_IMPLEMENTS: Syntax, Search for it |
ALL_JAVA_INNERS: Syntax, Search for it |
ALL_JAVA_LAYOUTS: Syntax, Search for it |
ALL_JAVA_METHODS: Syntax, Search for it |
ALL_JAVA_NCOMPS: Syntax, Search for it |
ALL_JAVA_RESOLVERS: Syntax, Search for it |
ALL_JAVA_THROWS: Syntax, Search for it |
ALL_JOBS: Syntax, Search for it |
ALL_JOIN_IND_COLUMNS: Syntax, Search for it |
ALL_LIBRARIES: Syntax, Search for it |
ALL_LOB_PARTITIONS: Syntax, Search for it |
ALL_LOB_SUBPARTITIONS: Syntax, Search for it |
ALL_LOB_TEMPLATES: Syntax, Search for it |
ALL_LOBS: Syntax, Search for it |
ALL_LOG_GROUP_COLUMNS: Syntax, Search for it |
ALL_LOG_GROUPS: Syntax, Search for it |
ALL_MEASURE_FOLDER_CONTENTS: Syntax, Search for it |
ALL_MEASURE_FOLDERS: Syntax, Search for it |
ALL_METHOD_PARAMS: Syntax, Search for it |
ALL_METHOD_RESULTS: Syntax, Search for it |
ALL_MINING_MODEL_ATTRIBUTES: Syntax, Search for it |
ALL_MINING_MODEL_SETTINGS: Syntax, Search for it |
ALL_MINING_MODELS: Syntax, Search for it |
ALL_MVIEW_AGGREGATES: Syntax, Search for it |
ALL_MVIEW_ANALYSIS: Syntax, Search for it |
ALL_MVIEW_COMMENTS: Syntax, Search for it |
ALL_MVIEW_DETAIL_PARTITION: Syntax, Search for it |
ALL_MVIEW_DETAIL_RELATIONS: Syntax, Search for it |
ALL_MVIEW_DETAIL_SUBPARTITION: Syntax, Search for it |
ALL_MVIEW_JOINS: Syntax, Search for it |
ALL_MVIEW_KEYS: Syntax, Search for it |
ALL_MVIEW_LOGS: Syntax, Search for it |
ALL_MVIEW_REFRESH_TIMES: Syntax, Search for it |
ALL_MVIEWS: Syntax, Search for it |
ALL_NESTED_TABLE_COLS: Syntax, Search for it |
ALL_NESTED_TABLES: Syntax, Search for it |
ALL_OBJ_COLATTRS: Syntax, Search for it |
ALL_OBJECT_TABLES: Syntax, Search for it |
ALL_OBJECTS: Syntax, Search for it |
ALL_OBJECTS_AE: Syntax, Search for it |
ALL_OPANCILLARY: Syntax, Search for it |
ALL_OPARGUMENTS: Syntax, Search for it |
ALL_OPBINDINGS: Syntax, Search for it |
ALL_OPERATOR_COMMENTS: Syntax, Search for it |
ALL_OPERATORS: Syntax, Search for it |
ALL_OUTLINE_HINTS: Syntax, Search for it |
ALL_OUTLINES: Syntax, Search for it |
ALL_PART_COL_STATISTICS: Syntax, Search for it |
ALL_PART_HISTOGRAMS: Syntax, Search for it |
ALL_PART_INDEXES: Syntax, Search for it |
ALL_PART_KEY_COLUMNS: Syntax, Search for it |
ALL_PART_LOBS: Syntax, Search for it |
ALL_PART_TABLES: Syntax, Search for it |
ALL_PARTIAL_DROP_TABS: Syntax, Search for it |
ALL_PENDING_CONV_TABLES: Syntax, Search for it |
ALL_PLSQL_OBJECT_SETTINGS: Syntax, Search for it |
ALL_POLICIES: Syntax, Search for it |
ALL_POLICY_CONTEXTS: Syntax, Search for it |
ALL_POLICY_GROUPS: Syntax, Search for it |
ALL_PROCEDURES: Syntax, Search for it |
ALL_PROPAGATION: Syntax, Search for it |
ALL_PUBLISHED_COLUMNS: Syntax, Search for it |
ALL_QUEUE_SCHEDULES: Syntax, Search for it |
ALL_QUEUE_SUBSCRIBERS: Syntax, Search for it |
ALL_QUEUE_TABLES: Syntax, Search for it |
ALL_QUEUES: Syntax, Search for it |
ALL_REFRESH: Syntax, Search for it |
ALL_REFRESH_CHILDREN: Syntax, Search for it |
ALL_REFRESH_DEPENDENCIES: Syntax, Search for it |
ALL_REFS: Syntax, Search for it |
ALL_REGISTERED_MVIEWS: Syntax, Search for it |
ALL_REGISTRY_BANNERS: Syntax, Search for it |
ALL_REWRITE_EQUIVALENCES: Syntax, Search for it |
ALL_RULE_SET_RULES: Syntax, Search for it |
ALL_RULE_SETS: Syntax, Search for it |
ALL_RULES: Syntax, Search for it |
ALL_SCHEDULER_CHAIN_RULES: Syntax, Search for it |
ALL_SCHEDULER_CHAIN_STEPS: Syntax, Search for it |
ALL_SCHEDULER_CHAINS: Syntax, Search for it |
ALL_SCHEDULER_CREDENTIALS: Syntax, Search for it |
ALL_SCHEDULER_DB_DESTS: Syntax, Search for it |
ALL_SCHEDULER_DESTS: Syntax, Search for it |
ALL_SCHEDULER_EXTERNAL_DESTS: Syntax, Search for it |
ALL_SCHEDULER_FILE_WATCHERS: Syntax, Search for it |
ALL_SCHEDULER_GLOBAL_ATTRIBUTE: Syntax, Search for it |
ALL_SCHEDULER_GROUP_MEMBERS: Syntax, Search for it |
ALL_SCHEDULER_GROUPS: Syntax, Search for it |
ALL_SCHEDULER_JOB_ARGS: Syntax, Search for it |
ALL_SCHEDULER_JOB_CLASSES: Syntax, Search for it |
ALL_SCHEDULER_JOB_DESTS: Syntax, Search for it |
ALL_SCHEDULER_JOB_LOG: Syntax, Search for it |
ALL_SCHEDULER_JOB_RUN_DETAILS: Syntax, Search for it |
ALL_SCHEDULER_JOBS: Syntax, Search for it |
ALL_SCHEDULER_NOTIFICATIONS: Syntax, Search for it |
ALL_SCHEDULER_PROGRAM_ARGS: Syntax, Search for it |
ALL_SCHEDULER_PROGRAMS: Syntax, Search for it |
ALL_SCHEDULER_REMOTE_DATABASES: Syntax, Search for it |
ALL_SCHEDULER_REMOTE_JOBSTATE: Syntax, Search for it |
ALL_SCHEDULER_RUNNING_CHAINS: Syntax, Search for it |
ALL_SCHEDULER_RUNNING_JOBS: Syntax, Search for it |
ALL_SCHEDULER_SCHEDULES: Syntax, Search for it |
ALL_SCHEDULER_WINDOW_DETAILS: Syntax, Search for it |
ALL_SCHEDULER_WINDOW_GROUPS: Syntax, Search for it |
ALL_SCHEDULER_WINDOW_LOG: Syntax, Search for it |
ALL_SCHEDULER_WINDOWS: Syntax, Search for it |
ALL_SCHEDULER_WINGROUP_MEMBERS: Syntax, Search for it |
ALL_SEC_RELEVANT_COLS: Syntax, Search for it |
ALL_SECONDARY_OBJECTS: Syntax, Search for it |
ALL_SEQUENCES: Syntax, Search for it |
ALL_SERVICES: Syntax, Search for it |
ALL_SOURCE: Syntax, Search for it |
ALL_SOURCE_AE: Syntax, Search for it |
ALL_SOURCE_TABLES: Syntax, Search for it |
ALL_SQLJ_TYPE_ATTRS: Syntax, Search for it |
ALL_SQLJ_TYPE_METHODS: Syntax, Search for it |
ALL_SQLJ_TYPES: Syntax, Search for it |
ALL_SQLSET: Syntax, Search for it |
ALL_SQLSET_BINDS: Syntax, Search for it |
ALL_SQLSET_PLANS: Syntax, Search for it |
ALL_SQLSET_REFERENCES: Syntax, Search for it |
ALL_SQLSET_STATEMENTS: Syntax, Search for it |
ALL_STAT_EXTENSIONS: Syntax, Search for it |
ALL_STORED_SETTINGS: Syntax, Search for it |
ALL_STREAMS_COLUMNS: Syntax, Search for it |
ALL_STREAMS_GLOBAL_RULES: Syntax, Search for it |
ALL_STREAMS_MESSAGE_CONSUMERS: Syntax, Search for it |
ALL_STREAMS_MESSAGE_RULES: Syntax, Search for it |
ALL_STREAMS_NEWLY_SUPPORTED: Syntax, Search for it |
ALL_STREAMS_RULES: Syntax, Search for it |
ALL_STREAMS_SCHEMA_RULES: Syntax, Search for it |
ALL_STREAMS_STMT_HANDLERS: Syntax, Search for it |
ALL_STREAMS_STMTS: Syntax, Search for it |
ALL_STREAMS_TABLE_RULES: Syntax, Search for it |
ALL_STREAMS_TRANSFORM_FUNCTION: Syntax, Search for it |
ALL_STREAMS_UNSUPPORTED: Syntax, Search for it |
ALL_SUBPART_COL_STATISTICS: Syntax, Search for it |
ALL_SUBPART_HISTOGRAMS: Syntax, Search for it |
ALL_SUBPART_KEY_COLUMNS: Syntax, Search for it |
ALL_SUBPARTITION_TEMPLATES: Syntax, Search for it |
ALL_SUBSCRIBED_COLUMNS: Syntax, Search for it |
ALL_SUBSCRIBED_TABLES: Syntax, Search for it |
ALL_SUBSCRIPTIONS: Syntax, Search for it |
ALL_SUMDELTA: Syntax, Search for it |
ALL_SYNC_CAPTURE: Syntax, Search for it |
ALL_SYNC_CAPTURE_PREPARED_TABS: Syntax, Search for it |
ALL_SYNC_CAPTURE_TABLES: Syntax, Search for it |
ALL_SYNONYMS: Syntax, Search for it |
ALL_TAB_COL_STATISTICS: Syntax, Search for it |
ALL_TAB_COLS: Syntax, Search for it |
ALL_TAB_COLUMNS: Syntax, Search for it |
ALL_TAB_COMMENTS: Syntax, Search for it |
ALL_TAB_HISTGRM_PENDING_STATS: Syntax, Search for it |
ALL_TAB_HISTOGRAMS: Syntax, Search for it |
ALL_TAB_MODIFICATIONS: Syntax, Search for it |
ALL_TAB_PARTITIONS: Syntax, Search for it |
ALL_TAB_PENDING_STATS: Syntax, Search for it |
ALL_TAB_PRIVS: Syntax, Search for it |
ALL_TAB_PRIVS_MADE: Syntax, Search for it |
ALL_TAB_PRIVS_RECD: Syntax, Search for it |
ALL_TAB_STAT_PREFS: Syntax, Search for it |
ALL_TAB_STATISTICS: Syntax, Search for it |
ALL_TAB_STATS_HISTORY: Syntax, Search for it |
ALL_TAB_SUBPARTITIONS: Syntax, Search for it |
ALL_TABLES: Syntax, Search for it |
ALL_TRANSFORMATIONS: Syntax, Search for it |
ALL_TRIGGER_COLS: Syntax, Search for it |
ALL_TRIGGER_ORDERING: Syntax, Search for it |
ALL_TRIGGERS: Syntax, Search for it |
ALL_TSTZ_TAB_COLS: Syntax, Search for it |
ALL_TSTZ_TABLES: Syntax, Search for it |
ALL_TYPE_ATTRS: Syntax, Search for it |
ALL_TYPE_METHODS: Syntax, Search for it |
ALL_TYPE_VERSIONS: Syntax, Search for it |
ALL_TYPES: Syntax, Search for it |
ALL_UNUSED_COL_TABS: Syntax, Search for it |
ALL_UPDATABLE_COLUMNS: Syntax, Search for it |
ALL_USERS: Syntax, Search for it |
ALL_USTATS: Syntax, Search for it |
ALL_VARRAYS: Syntax, Search for it |
ALL_VIEWS: Syntax, Search for it |
ALL_VIEWS_AE: Syntax, Search for it |
ALL_WARNING_SETTINGS: Syntax, Search for it |
ALL_XML_INDEXES: Syntax, Search for it |
ALL_XML_SCHEMAS: Syntax, Search for it |
ALL_XML_TAB_COLS: Syntax, Search for it |
ALL_XML_TABLES: Syntax, Search for it |
ALL_XML_VIEW_COLS: Syntax, Search for it |
ALL_XML_VIEWS: Syntax, Search for it |
ALL_XSTREAM_INBOUND: Syntax, Search for it |
ALL_XSTREAM_INBOUND_PROGRESS: Syntax, Search for it |
ALL_XSTREAM_OUTBOUND: Syntax, Search for it |
ALL_XSTREAM_OUTBOUND_PROGRESS: Syntax, Search for it |
ALL_XSTREAM_RULES: Syntax, Search for it |