DBA Data[Home] [Help]

VIEW: SYS.DBA_APPLY_ENQUEUE

Source

View Text - Preformatted

select r.rule_owner, r.rule_name, sys.anydata.AccessVarchar2(ctx.nvn_value)
from DBA_RULES r, table(r.rule_action_context.actx_list) ctx
where ctx.nvn_name = 'APPLY$_ENQUEUE'
View Text - HTML Formatted

SELECT R.RULE_OWNER
, R.RULE_NAME
, SYS.ANYDATA.ACCESSVARCHAR2(CTX.NVN_VALUE) FROM DBA_RULES R
, TABLE(R.RULE_ACTION_CONTEXT.ACTX_LIST) CTX WHERE CTX.NVN_NAME = 'APPLY$_ENQUEUE'