Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


ALL_STREAMS_MESSAGE_RULES displays information about the Streams messaging rules accessible to the current user.

Related View

DBA_STREAMS_MESSAGE_RULES displays information about all Streams messaging rules in the database.

Column Datatype NULL Description
STREAMS_NAME VARCHAR2(30)   Name of the Streams client
STREAMS_TYPE VARCHAR2(11)   Type of the Streams client:
  • PROPAGATION - Streams propagation

  • APPLY - Streams apply process

  • DEQUEUE - Streams messaging client

MESSAGE_TYPE_NAME VARCHAR2(30)   Name of the message type
MESSAGE_TYPE_OWNER VARCHAR2(30)   Owner of the message type
MESSAGE_RULE_VARIABLE VARCHAR2(30)   Name of the variable in the message rule
RULE_NAME VARCHAR2(30) NOT NULL Name of the rule
RULE_OWNER VARCHAR2(30) NOT NULL Owner of the rule
RULE_CONDITION VARCHAR2(4000)   Rule condition