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) NOT NULL 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