 Home |
 Help |
 Contact Us |
|
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_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_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_ASSOCIATIONS: 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_CLUSTER_HASH_EXPRESSIONS: Syntax, Search for it |
| ALL_CLUSTERS: Syntax, Search for it |
| ALL_COL_COMMENTS: 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_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_ENCRYPTED_COLUMNS: Syntax, Search for it |
| ALL_ERRORS: 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_IND_COLUMNS: Syntax, Search for it |
| ALL_IND_EXPRESSIONS: Syntax, Search for it |
| ALL_IND_PARTITIONS: 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_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_METHOD_PARAMS: Syntax, Search for it |
| ALL_METHOD_RESULTS: 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_RELATIONS: 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_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_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_GLOBAL_ATTRIBUTE: Syntax, Search for it |
| ALL_SCHEDULER_JOB_ARGS: Syntax, Search for it |
| ALL_SCHEDULER_JOB_CLASSES: 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_PROGRAM_ARGS: Syntax, Search for it |
| ALL_SCHEDULER_PROGRAMS: 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_SEQUENCES: Syntax, Search for it |
| ALL_SERVICES: Syntax, Search for it |
| ALL_SOURCE: 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_STORED_SETTINGS: 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_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_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_HISTOGRAMS: Syntax, Search for it |
| ALL_TAB_MODIFICATIONS: Syntax, Search for it |
| ALL_TAB_PARTITIONS: 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_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_TRIGGER_COLS: Syntax, Search for it |
| ALL_TRIGGERS: 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_WARNING_SETTINGS: 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 |
