iSelfSchooling.com Since 1999 References | Search more | Oracle Syntax | Free Online Oracle Training

Home .Services Login Start Learning Certification . .Share your BELIEF(s)...

. Online Accounting     .Copyright & User Agreement   |

    .Vision      .Biography     .Acknowledgement
.Contact Us      .Comments/Suggestions       Email2aFriend    |

Complete Syntax | Oracle Functions | PL/SQL Syntax | SQL Syntax | Tables

Oracle Dictionary Tables

ALL_ | DBA_ | USER_ | GV$ | V$ | Others

2PC... | APP... | CAP... | EXP... | HIS... | HIS... | IND... | LOC... | OPA... | REC... | REP... | SCH... | STR... | TAB...

DBA_SCHEDULER_WINDOW_LOG: Logged information for all scheduler windows

iSelfSchooling-SQL> desc DBA_SCHEDULER_WINDOW_LOG;

Name Null? Type

----------------------------- -------- --------------------

LOG_ID NOT NULL NUMBER

LOG_DATE TIMESTAMP(6)

WINDOW_NAME VARCHAR2(65)

OPERATION VARCHAR2(30)

STATUS VARCHAR2(30)

USER_NAME VARCHAR2(30)

CLIENT_ID VARCHAR2(64)

GLOBAL_UID VARCHAR2(32)

ADDITIONAL_INFO CLOB

DBA_SCHEDULER_WINGROUP_MEMBERS: Members of all scheduler window groups in the database

iSelfSchooling-SQL> desc DBA_SCHEDULER_WINGROUP_MEMBERS;

Name Null? Type

----------------------------- -------- --------------------

WINDOW_GROUP_NAME NOT NULL VARCHAR2(30)

WINDOW_NAME NOT NULL VARCHAR2(30)

DBA_SECONDARY_OBJECTS: All secondary objects for domain indexes

iSelfSchooling-SQL> desc DBA_SECONDARY_OBJECTS;

Name Null? Type

----------------------------- -------- --------------------

INDEX_OWNER NOT NULL VARCHAR2(30)

INDEX_NAME NOT NULL VARCHAR2(30)

SECONDARY_OBJECT_OWNER NOT NULL VARCHAR2(30)

SECONDARY_OBJECT_NAME NOT NULL VARCHAR2(30)

DBA_SEC_RELEVANT_COLS: Security Relevant columns of all VPD policies in the database

iSelfSchooling-SQL> desc DBA_SEC_RELEVANT_COLS;

Name Null? Type

----------------------------- -------- --------------------

OBJECT_OWNER NOT NULL VARCHAR2(30)

OBJECT_NAME NOT NULL VARCHAR2(30)

POLICY_GROUP NOT NULL VARCHAR2(30)

POLICY_NAME NOT NULL VARCHAR2(30)

SEC_REL_COLUMN NOT NULL VARCHAR2(30)

COLUMN_OPTION VARCHAR2(8)

DBA_SEGMENTS: Storage allocated for all database segments

iSelfSchooling-SQL> desc DBA_SEGMENTS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

SEGMENT_NAME VARCHAR2(81)

PARTITION_NAME VARCHAR2(30)

SEGMENT_TYPE VARCHAR2(18)

TABLESPACE_NAME VARCHAR2(30)

HEADER_FILE NUMBER

HEADER_BLOCK NUMBER

BYTES NUMBER

BLOCKS NUMBER

EXTENTS NUMBER

INITIAL_EXTENT NUMBER

NEXT_EXTENT NUMBER

MIN_EXTENTS NUMBER

MAX_EXTENTS NUMBER

PCT_INCREASE NUMBER

FREELISTS NUMBER

FREELIST_GROUPS NUMBER

RELATIVE_FNO NUMBER

BUFFER_POOL VARCHAR2(7)

DBA_SEGMENTS_OLD: Storage allocated for all database segments

iSelfSchooling-SQL> desc DBA_SEGMENTS_OLD;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

SEGMENT_NAME VARCHAR2(81)

PARTITION_NAME VARCHAR2(30)

SEGMENT_TYPE VARCHAR2(18)

TABLESPACE_NAME VARCHAR2(30)

HEADER_FILE NUMBER

HEADER_BLOCK NUMBER

BYTES NUMBER

BLOCKS NUMBER

EXTENTS NUMBER

INITIAL_EXTENT NUMBER

NEXT_EXTENT NUMBER

MIN_EXTENTS NUMBER

MAX_EXTENTS NUMBER

PCT_INCREASE NUMBER

FREELISTS NUMBER

FREELIST_GROUPS NUMBER

RELATIVE_FNO NUMBER

BUFFER_POOL VARCHAR2(7)

DBA_SEQUENCES: Description of all SEQUENCEs in the database

iSelfSchooling-SQL> desc DBA_SEQUENCES;

Name Null? Type

----------------------------- -------- --------------------

SEQUENCE_OWNER NOT NULL VARCHAR2(30)

SEQUENCE_NAME NOT NULL VARCHAR2(30)

MIN_VALUE NUMBER

MAX_VALUE NUMBER

INCREMENT_BY NOT NULL NUMBER

CYCLE_FLAG VARCHAR2(1)

ORDER_FLAG VARCHAR2(1)

CACHE_SIZE NOT NULL NUMBER

LAST_NUMBER NOT NULL NUMBER

DBA_SERVER_REGISTRY

iSelfSchooling-SQL> desc DBA_SERVER_REGISTRY;

Name Null? Type

----------------------------- -------- --------------------

COMP_ID NOT NULL VARCHAR2(30)

COMP_NAME VARCHAR2(255)

VERSION VARCHAR2(30)

STATUS VARCHAR2(11)

MODIFIED VARCHAR2(20)

CONTROL NOT NULL VARCHAR2(30)

SCHEMA NOT NULL VARCHAR2(30)

PROCEDURE VARCHAR2(61)

STARTUP VARCHAR2(8)

PARENT_ID VARCHAR2(30)

OTHER_SCHEMAS VARCHAR2(4000)

DBA_SNAPSHOTS: All snapshots in the database

iSelfSchooling-SQL> desc DBA_SNAPSHOTS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

NAME NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

MASTER_VIEW VARCHAR2(30)

MASTER_OWNER VARCHAR2(30)

MASTER VARCHAR2(30)

MASTER_LINK VARCHAR2(128)

CAN_USE_LOG VARCHAR2(3)

UPDATABLE VARCHAR2(3)

REFRESH_METHOD VARCHAR2(11)

LAST_REFRESH DATE

ERROR NUMBER

FR_OPERATIONS VARCHAR2(10)

CR_OPERATIONS VARCHAR2(10)

TYPE VARCHAR2(8)

NEXT VARCHAR2(200)

START_WITH DATE

REFRESH_GROUP NUMBER

UPDATE_TRIG VARCHAR2(30)

UPDATE_LOG VARCHAR2(30)

QUERY LONG

MASTER_ROLLBACK_SEG VARCHAR2(30)

STATUS VARCHAR2(7)

REFRESH_MODE VARCHAR2(8)

PREBUILT VARCHAR2(3)

DBA_SNAPSHOT_LOGS: All snapshot logs in the database

iSelfSchooling-SQL> desc DBA_SNAPSHOT_LOGS;

Name Null? Type

----------------------------- -------- --------------------

LOG_OWNER VARCHAR2(30)

MASTER VARCHAR2(30)

LOG_TABLE VARCHAR2(30)

LOG_TRIGGER VARCHAR2(30)

ROWIDS VARCHAR2(3)

PRIMARY_KEY VARCHAR2(3)

OBJECT_ID VARCHAR2(3)

FILTER_COLUMNS VARCHAR2(3)

SEQUENCE VARCHAR2(3)

INCLUDE_NEW_VALUES VARCHAR2(3)

CURRENT_SNAPSHOTS DATE

SNAPSHOT_ID NUMBER(38)

DBA_SNAPSHOT_LOG_FILTER_COLS: Synonym for DBA_MVIEW_LOG_FILTER_COLS

iSelfSchooling-SQL> desc DBA_SNAPSHOT_LOG_FILTER_COLS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(30)

DBA_SNAPSHOT_REFRESH_TIMES: Synonym for DBA_MVIEW_REFRESH_TIMES

iSelfSchooling-SQL> desc DBA_SNAPSHOT_REFRESH_TIMES;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

NAME NOT NULL VARCHAR2(30)

MASTER_OWNER VARCHAR2(30)

MASTER VARCHAR2(30)

LAST_REFRESH DATE

DBA_SOURCE: Source of all stored objects in the database

iSelfSchooling-SQL> desc DBA_SOURCE;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

NAME VARCHAR2(30)

TYPE VARCHAR2(12)

LINE NUMBER

TEXT VARCHAR2(4000)

DBA_SOURCE_TABLES: Source tables available for Change Data Capture

iSelfSchooling-SQL> desc DBA_SOURCE_TABLES;

Name Null? Type

----------------------------- -------- --------------------

SOURCE_SCHEMA_NAME NOT NULL VARCHAR2(30)

SOURCE_TABLE_NAME NOT NULL VARCHAR2(30)

DBA_SQLJ_TYPES: Description of all types in the database

iSelfSchooling-SQL> desc DBA_SQLJ_TYPES;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

TYPE_NAME NOT NULL VARCHAR2(30)

TYPE_OID NOT NULL RAW(16)

EXTERNAL_NAME VARCHAR2(4000)

USING VARCHAR2(21)

TYPECODE VARCHAR2(30)

ATTRIBUTES NUMBER

METHODS NUMBER

PREDEFINED VARCHAR2(3)

INCOMPLETE VARCHAR2(3)

FINAL VARCHAR2(3)

INSTANTIABLE VARCHAR2(3)

SUPERTYPE_OWNER VARCHAR2(30)

SUPERTYPE_NAME VARCHAR2(30)

LOCAL_ATTRIBUTES NUMBER

LOCAL_METHODS NUMBER

DBA_SQLJ_TYPE_ATTRS: Description of attributes of all types in the database

iSelfSchooling-SQL> desc DBA_SQLJ_TYPE_ATTRS;

Name Null? Type

----------------------------- -------- --------------------

OWNER VARCHAR2(30)

TYPE_NAME NOT NULL VARCHAR2(30)

ATTR_NAME NOT NULL VARCHAR2(30)

EXTERNAL_ATTR_NAME VARCHAR2(4000)

ATTR_TYPE_MOD VARCHAR2(7)

ATTR_TYPE_OWNER VARCHAR2(30)

ATTR_TYPE_NAME VARCHAR2(30)

LENGTH NUMBER

PRECISION NUMBER

SCALE NUMBER

CHARACTER_SET_NAME VARCHAR2(44)

ATTR_NO NOT NULL NUMBER

INHERITED VARCHAR2(3)

DBA_SQLJ_TYPE_METHODS: Description of methods of all types in the database

iSelfSchooling-SQL> desc DBA_SQLJ_TYPE_METHODS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

TYPE_NAME NOT NULL VARCHAR2(30)

METHOD_NAME NOT NULL VARCHAR2(30)

EXTERNAL_VAR_NAME VARCHAR2(4000)

METHOD_NO NOT NULL NUMBER

METHOD_TYPE VARCHAR2(6)

PARAMETERS NOT NULL NUMBER

RESULTS NOT NULL NUMBER

FINAL VARCHAR2(3)

INSTANTIABLE VARCHAR2(3)

OVERRIDING VARCHAR2(3)

INHERITED VARCHAR2(3)

DBA_SQLSET

iSelfSchooling-SQL> desc DBA_SQLSET;

Name Null? Type

----------------------------- -------- --------------------

ID NOT NULL NUMBER

NAME NOT NULL VARCHAR2(30)

OWNER VARCHAR2(30)

DESCRIPTION VARCHAR2(256)

CREATED DATE

LAST_MODIFIED DATE

STATEMENT_COUNT NUMBER

DBA_SQLSET_BINDS

iSelfSchooling-SQL> desc DBA_SQLSET_BINDS;

Name Null? Type

----------------------------- -------- --------------------

SQLSET_NAME VARCHAR2(30)

SQLSET_OWNER VARCHAR2(30)

SQLSET_ID NUMBER

SQL_ID VARCHAR2(13)

FORCE_MATCHING_SIGNATURE NUMBER

PLAN_HASH_VALUE NUMBER

POSITION NUMBER

VALUE ANYDATA

CAPTURED CHAR(1)

SQL_SEQ NUMBER

DBA_SQLSET_DEFINITIONS: Synonym for DBA_SQLSET

iSelfSchooling-SQL> desc DBA_SQLSET_DEFINITIONS;

Name Null? Type

----------------------------- -------- --------------------

ID NOT NULL NUMBER

NAME NOT NULL VARCHAR2(30)

OWNER VARCHAR2(30)

DESCRIPTION VARCHAR2(256)

CREATED DATE

LAST_MODIFIED DATE

STATEMENT_COUNT NUMBER

DBA_SQLSET_PLANS

iSelfSchooling-SQL> desc DBA_SQLSET_PLANS;

Name Null? Type

----------------------------- -------- --------------------

SQLSET_NAME NOT NULL VARCHAR2(30)

SQLSET_OWNER VARCHAR2(30)

SQLSET_ID NOT NULL NUMBER

SQL_ID NOT NULL VARCHAR2(13)

FORCE_MATCHING_SIGNATURE NOT NULL NUMBER

PLAN_HASH_VALUE NOT NULL NUMBER

SQL_SEQ NOT NULL NUMBER

STATEMENT_ID VARCHAR2(30)

PLAN_ID NUMBER

TIMESTAMP DATE

REMARKS VARCHAR2(4000)

OPERATION VARCHAR2(30)

OPTIONS VARCHAR2(255)

OBJECT_NODE VARCHAR2(128)

OBJECT_OWNER VARCHAR2(30)

OBJECT_NAME VARCHAR2(30)

OBJECT_ALIAS VARCHAR2(65)

OBJECT_INSTANCE NUMBER(38)

OBJECT_TYPE VARCHAR2(30)

OPTIMIZER VARCHAR2(255)

SEARCH_COLUMNS NUMBER

ID NOT NULL NUMBER(38)

PARENT_ID NUMBER(38)

DEPTH NUMBER(38)

POSITION NUMBER(38)

COST NUMBER(38)

CARDINALITY NUMBER(38)

BYTES NUMBER(38)

OTHER_TAG VARCHAR2(255)

PARTITION_START VARCHAR2(255)

PARTITION_STOP VARCHAR2(255)

PARTITION_ID NUMBER(38)

OTHER LONG

DISTRIBUTION VARCHAR2(30)

CPU_COST NUMBER(38)

IO_COST NUMBER(38)

TEMP_SPACE NUMBER(38)

ACCESS_PREDICATES VARCHAR2(4000)

FILTER_PREDICATES VARCHAR2(4000)

PROJECTION VARCHAR2(4000)

TIME NUMBER(38)

QBLOCK_NAME VARCHAR2(30)

OTHER_XML CLOB

EXECUTIONS NUMBER

STARTS NUMBER

OUTPUT_ROWS NUMBER

CR_BUFFER_GETS NUMBER

CU_BUFFER_GETS NUMBER

DISK_READS NUMBER

DISK_WRITES NUMBER

ELAPSED_TIME NUMBER

DBA_SQLSET_REFERENCES

iSelfSchooling-SQL> desc DBA_SQLSET_REFERENCES;

Name Null? Type

----------------------------- -------- --------------------

SQLSET_NAME NOT NULL VARCHAR2(30)

SQLSET_OWNER VARCHAR2(30)

SQLSET_ID NOT NULL NUMBER

ID NOT NULL NUMBER

OWNER VARCHAR2(30)

CREATED DATE

DESCRIPTION VARCHAR2(256)

DBA_SQLSET_STATEMENTS

iSelfSchooling-SQL> desc DBA_SQLSET_STATEMENTS;

Name Null? Type

----------------------------- -------- --------------------

SQLSET_NAME NOT NULL VARCHAR2(30)

SQLSET_OWNER VARCHAR2(30)

SQLSET_ID NOT NULL NUMBER

SQL_ID NOT NULL VARCHAR2(13)

FORCE_MATCHING_SIGNATURE NOT NULL NUMBER

SQL_TEXT CLOB

PARSING_SCHEMA_NAME VARCHAR2(30)

PARSING_SCHEMA_ID NUMBER

PLAN_HASH_VALUE NOT NULL NUMBER

BIND_DATA RAW(2000)

BINDS_CAPTURED CHAR(1)

MODULE VARCHAR2(48)

ACTION VARCHAR2(32)

ELAPSED_TIME NUMBER

CPU_TIME NUMBER

BUFFER_GETS NUMBER

DISK_READS NUMBER

DIRECT_WRITES NUMBER

ROWS_PROCESSED NUMBER

FETCHES NUMBER

EXECUTIONS NUMBER

END_OF_FETCH_COUNT NUMBER

OPTIMIZER_COST NUMBER

OPTIMIZER_ENV RAW(1000)

PRIORITY NUMBER

COMMAND_TYPE NUMBER

FIRST_LOAD_TIME VARCHAR2(19)

STAT_PERIOD NUMBER

ACTIVE_STAT_PERIOD NUMBER

OTHER CLOB

PLAN_TIMESTAMP DATE

SQL_SEQ NOT NULL NUMBER

DBA_SQLTUNE_BINDS

iSelfSchooling-SQL> desc DBA_SQLTUNE_BINDS;

Name Null? Type

----------------------------- -------- --------------------

TASK_ID NOT NULL NUMBER(38)

OBJECT_ID NOT NULL NUMBER(38)

POSITION NOT NULL NUMBER(38)

VALUE ANYDATA

DBA_SQLTUNE_PLANS

iSelfSchooling-SQL> desc DBA_SQLTUNE_PLANS;

Name Null? Type

----------------------------- -------- --------------------

TASK_ID NOT NULL NUMBER(38)

OBJECT_ID NOT NULL NUMBER(38)

ATTRIBUTE VARCHAR2(27)

STATEMENT_ID VARCHAR2(30)

PLAN_HASH_VALUE NOT NULL NUMBER

PLAN_ID NUMBER

TIMESTAMP DATE

REMARKS VARCHAR2(4000)

OPERATION VARCHAR2(30)

OPTIONS VARCHAR2(255)

OBJECT_NODE VARCHAR2(128)

OBJECT_OWNER VARCHAR2(30)

OBJECT_NAME VARCHAR2(30)

OBJECT_ALIAS VARCHAR2(65)

OBJECT_INSTANCE NUMBER(38)

OBJECT_TYPE VARCHAR2(30)

OPTIMIZER VARCHAR2(255)

SEARCH_COLUMNS NUMBER

ID NOT NULL NUMBER(38)

PARENT_ID NUMBER(38)

DEPTH NUMBER(38)

POSITION NUMBER(38)

COST NUMBER(38)

CARDINALITY NUMBER(38)

BYTES NUMBER(38)

OTHER_TAG VARCHAR2(255)

PARTITION_START VARCHAR2(255)

PARTITION_STOP VARCHAR2(255)

PARTITION_ID NUMBER(38)

OTHER LONG

DISTRIBUTION VARCHAR2(30)

CPU_COST NUMBER(38)

IO_COST NUMBER(38)

TEMP_SPACE NUMBER(38)

ACCESS_PREDICATES VARCHAR2(4000)

FILTER_PREDICATES VARCHAR2(4000)

PROJECTION VARCHAR2(4000)

TIME NUMBER(38)

QBLOCK_NAME VARCHAR2(30)

OTHER_XML CLOB

DBA_SQLTUNE_RATIONALE_PLAN

iSelfSchooling-SQL> desc DBA_SQLTUNE_RATIONALE_PLAN;

Name Null? Type

----------------------------- -------- --------------------

TASK_ID NOT NULL NUMBER(38)

RATIONALE_ID NOT NULL NUMBER(38)

OBJECT_ID NOT NULL NUMBER(38)

OPERATION_ID NOT NULL NUMBER(38)

PLAN_ATTRIBUTE VARCHAR2(27)

DBA_SQLTUNE_STATISTICS

iSelfSchooling-SQL> desc DBA_SQLTUNE_STATISTICS;

Name Null? Type

----------------------------- -------- --------------------

TASK_ID NOT NULL NUMBER(38)

OBJECT_ID NOT NULL NUMBER(38)

PARSING_SCHEMA_ID NUMBER

MODULE VARCHAR2(48)

ACTION VARCHAR2(32)

ELAPSED_TIME NUMBER

CPU_TIME NUMBER

BUFFER_GETS NUMBER

DISK_READS NUMBER

DIRECT_WRITES NUMBER

ROWS_PROCESSED NUMBER

FETCHES NUMBER

EXECUTIONS NUMBER

END_OF_FETCH_COUNT NUMBER

OPTIMIZER_COST NUMBER

OPTIMIZER_ENV RAW(1000)

COMMAND_TYPE NUMBER

DBA_STMT_AUDIT_OPTS: Describes current system auditing options across the system and by user

iSelfSchooling-SQL> desc DBA_STMT_AUDIT_OPTS;

Name Null? Type

----------------------------- -------- --------------------

USER_NAME VARCHAR2(30)

PROXY_NAME VARCHAR2(30)

AUDIT_OPTION NOT NULL VARCHAR2(40)

SUCCESS VARCHAR2(10)

FAILURE VARCHAR2(10)

DBA_STORED_SETTINGS: Parameter settings for all objects

iSelfSchooling-SQL> desc DBA_STORED_SETTINGS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

OBJECT_NAME NOT NULL VARCHAR2(30)

OBJECT_ID NOT NULL NUMBER

OBJECT_TYPE VARCHAR2(12)

PARAM_NAME NOT NULL VARCHAR2(30)

PARAM_VALUE VARCHAR2(4000)

DBA_STREAMS_ADD_COLUMN: Add column transformations

iSelfSchooling-SQL> desc DBA_STREAMS_ADD_COLUMN;

Name Null? Type

----------------------------- -------- --------------------

RULE_OWNER VARCHAR2(30)

RULE_NAME VARCHAR2(30)

SCHEMA_NAME VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

COLUMN_VALUE ANYDATA

COLUMN_TYPE VARCHAR2(4000)

COLUMN_FUNCTION VARCHAR2(30)

VALUE_TYPE VARCHAR2(3)

PRECEDENCE NUMBER

STEP_NUMBER NUMBER

DBA_STREAMS_ADMINISTRATOR: Users granted the privileges to be a streams administrator

iSelfSchooling-SQL> desc DBA_STREAMS_ADMINISTRATOR;

Name Null? Type

----------------------------- -------- --------------------

USERNAME NOT NULL VARCHAR2(30)

LOCAL_PRIVILEGES VARCHAR2(3)

ACCESS_FROM_REMOTE VARCHAR2(3)

DBA_STREAMS_DELETE_COLUMN: Delete column transformations

iSelfSchooling-SQL> desc DBA_STREAMS_DELETE_COLUMN;

Name Null? Type

----------------------------- -------- --------------------

RULE_OWNER VARCHAR2(30)

RULE_NAME VARCHAR2(30)

SCHEMA_NAME VARCHAR2(30)

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

VALUE_TYPE VARCHAR2(3)

PRECEDENCE NUMBER

STEP_NUMBER NUMBER

DBA_STREAMS_GLOBAL_RULES: Global rules created by streams administrative APIs

iSelfSchooling-SQL> desc DBA_STREAMS_GLOBAL_RULES;

Name Null? Type

----------------------------- -------- --------------------

STREAMS_NAME VARCHAR2(30)

STREAMS_TYPE VARCHAR2(11)

RULE_TYPE VARCHAR2(7)

INCLUDE_TAGGED_LCR VARCHAR2(3)

SOURCE_DATABASE VARCHAR2(128)

RULE_NAME VARCHAR2(30)

RULE_OWNER VARCHAR2(30)

RULE_CONDITION VARCHAR2(4000)

DBA_STREAMS_MESSAGE_CONSUMERS: Streams messaging consumers

iSelfSchooling-SQL> desc DBA_STREAMS_MESSAGE_CONSUMERS;

Name Null? Type

----------------------------- -------- --------------------

STREAMS_NAME NOT NULL VARCHAR2(30)

QUEUE_NAME NOT NULL VARCHAR2(30)

QUEUE_OWNER NOT NULL VARCHAR2(30)

RULE_SET_NAME VARCHAR2(30)

RULE_SET_OWNER VARCHAR2(30)

NEGATIVE_RULE_SET_NAME VARCHAR2(30)

NEGATIVE_RULE_SET_OWNER VARCHAR2(30)

NOTIFICATION_TYPE VARCHAR2(9)

NOTIFICATION_ACTION VARCHAR2(256)

NOTIFICATION_CONTEXT ANYDATA

DBA_STREAMS_MESSAGE_RULES: Rules for Streams messaging

iSelfSchooling-SQL> desc DBA_STREAMS_MESSAGE_RULES;

Name Null? Type

----------------------------- -------- --------------------

STREAMS_NAME NOT NULL VARCHAR2(30)

STREAMS_TYPE VARCHAR2(11)

MESSAGE_TYPE_NAME VARCHAR2(30)

MESSAGE_TYPE_OWNER VARCHAR2(30)

MESSAGE_RULE_VARIABLE VARCHAR2(30)

RULE_NAME NOT NULL VARCHAR2(30)

RULE_OWNER NOT NULL VARCHAR2(30)

RULE_CONDITION VARCHAR2(4000)