VIEW: DVSYS.KU$_DV_RULE_VIEW

Source

View Text - Preformatted

select '0','0',
          rult.name,
          rul.rule_expr,
          rult.language
  from    dvsys.rule$                   rul,
          dvsys.rule_t$                 rult
  where   rul.id# = rult.id#
    and   rul.id# >= 5000
    and   rul.id# not in (select rule_id#
                            from dvsys.rule_set_rule$
                           where rule_set_id# = 8)
    and   (SYS_CONTEXT('USERENV','CURRENT_USERID') = 1279990
           or exists ( select 1
                         from sys.session_roles
                        where role='DV_OWNER' ))

View Text - HTML Formatted

SELECT '0'
, '0'
, RULT.NAME
, RUL.RULE_EXPR
, RULT.LANGUAGE
FROM DVSYS.RULE$ RUL
, DVSYS.RULE_T$ RULT
WHERE RUL.ID# = RULT.ID#
AND RUL.ID# >= 5000
AND RUL.ID# NOT IN (SELECT RULE_ID#
FROM DVSYS.RULE_SET_RULE$
WHERE RULE_SET_ID# = 8)
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 1279990 OR EXISTS ( SELECT 1
FROM SYS.SESSION_ROLES
WHERE ROLE='DV_OWNER' ))