DBA Data[Home] [Help]

VIEW: SYS._DBA_STREAMS_RULES

Source

View Text - Preformatted

select
  streams_name, streams_type, rule_type, include_tagged_lcr,
  source_database, rule_owner, rule_name, rule_condition, dml_condition,
  subsetting_operation, schema_name, object_name, object_type,
  spare1, spare2, spare3, source_root_name
from sys.streams$_rules
View Text - HTML Formatted

SELECT STREAMS_NAME
, STREAMS_TYPE
, RULE_TYPE
, INCLUDE_TAGGED_LCR
, SOURCE_DATABASE
, RULE_OWNER
, RULE_NAME
, RULE_CONDITION
, DML_CONDITION
, SUBSETTING_OPERATION
, SCHEMA_NAME
, OBJECT_NAME
, OBJECT_TYPE
, SPARE1
, SPARE2
, SPARE3
, SOURCE_ROOT_NAME FROM SYS.STREAMS$_RULES