VIEW: SYS._DBA_STREAMS_TRANSFM_FUNCTION

Source

View Text - Preformatted

select r.rule_owner, r.rule_name, SYS.ANYDATA.GetTypeName(ctx.nvn_value),
       DECODE(SYS.ANYDATA.GetTypeName(ctx.nvn_value),
              'SYS.VARCHAR2', SYS.ANYDATA.AccessVarchar2(ctx.nvn_value),
              NULL),
       DECODE(ctx.nvn_name, 'STREAMS$_TRANSFORM_FUNCTION', 'ONE TO ONE',
                            'STREAMS$_ARRAY_TRANS_FUNCTION', 'ONE TO MANY')
from   DBA_RULES r, table(r.rule_action_context.actx_list) ctx
where  ctx.nvn_name = 'STREAMS$_TRANSFORM_FUNCTION'
   OR  ctx.nvn_name = 'STREAMS$_ARRAY_TRANS_FUNCTION'

View Text - HTML Formatted

SELECT R.RULE_OWNER
, R.RULE_NAME
, SYS.ANYDATA.GETTYPENAME(CTX.NVN_VALUE)
, DECODE(SYS.ANYDATA.GETTYPENAME(CTX.NVN_VALUE)
, 'SYS.VARCHAR2'
, SYS.ANYDATA.ACCESSVARCHAR2(CTX.NVN_VALUE)
, NULL)
, DECODE(CTX.NVN_NAME
, 'STREAMS$_TRANSFORM_FUNCTION'
, 'ONE TO ONE'
, 'STREAMS$_ARRAY_TRANS_FUNCTION'
, 'ONE TO MANY') FROM DBA_RULES R
, TABLE(R.RULE_ACTION_CONTEXT.ACTX_LIST) CTX WHERE CTX.NVN_NAME = 'STREAMS$_TRANSFORM_FUNCTION' OR CTX.NVN_NAME = 'STREAMS$_ARRAY_TRANS_FUNCTION'