VIEW: SYS._DBA_STREAMS_TP_COMPONENT_PROP

Source

View Text - Preformatted

SELECT C.COMPONENT_ID,
       nvl(C.COMPONENT_NAME, C.SPARE3) COMPONENT_NAME,
       C.COMPONENT_DB,
       decode(C.COMPONENT_TYPE,
              1, 'CAPTURE',
              2, 'PROPAGATION SENDER',
              3, 'PROPAGATION RECEIVER',
              4, 'APPLY',
              5, 'QUEUE',
              6, 'EXTRACT',
              7, 'REPLICAT',
              NULL),
       P.PROP_NAME,
       P.PROP_VALUE
FROM streams$_component C,
     streams$_component_prop P
WHERE C.COMPONENT_ID = P.COMPONENT_ID

View Text - HTML Formatted

SELECT C.COMPONENT_ID
, NVL(C.COMPONENT_NAME
, C.SPARE3) COMPONENT_NAME
, C.COMPONENT_DB
, DECODE(C.COMPONENT_TYPE
, 1
, 'CAPTURE'
, 2
, 'PROPAGATION SENDER'
, 3
, 'PROPAGATION RECEIVER'
, 4
, 'APPLY'
, 5
, 'QUEUE'
, 6
, 'EXTRACT'
, 7
, 'REPLICAT'
, NULL)
, P.PROP_NAME
, P.PROP_VALUE FROM STREAMS$_COMPONENT C
, STREAMS$_COMPONENT_PROP P WHERE C.COMPONENT_ID = P.COMPONENT_ID