DBA Data[Home] [Help]

VIEW: SYS.ALL_STREAMS_TRANSFORM_FUNCTION

Source

View Text - Preformatted

select tf."RULE_OWNER",tf."RULE_NAME",tf."VALUE_TYPE",tf."TRANSFORM_FUNCTION_NAME",tf."CUSTOM_TYPE"
from   DBA_STREAMS_TRANSFORM_FUNCTION tf, ALL_RULES r
where  tf.rule_owner = r.rule_owner
and    tf.rule_name = r.rule_name
View Text - HTML Formatted

SELECT TF."RULE_OWNER"
, TF."RULE_NAME"
, TF."VALUE_TYPE"
, TF."TRANSFORM_FUNCTION_NAME"
, TF."CUSTOM_TYPE" FROM DBA_STREAMS_TRANSFORM_FUNCTION TF
, ALL_RULES R WHERE TF.RULE_OWNER = R.RULE_OWNER AND TF.RULE_NAME = R.RULE_NAME