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
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
|
|
|