VIEW: DVSYS.KU$_DV_FACTOR_VIEW

Source

View Text - Preformatted

select '0','0',
         m.name,
         dft.name,
         d.description,
         d.language,
         drs.name,
         m.get_expr,
         m.validate_expr,
         decode(m.identified_by,
                 0,'DVSYS.DBMS_MACUTL.G_IDENTIFY_BY_CONSTANT',
                 1,'DVSYS.DBMS_MACUTL.G_IDENTIFY_BY_METHOD',
                 2,'DVSYS.DBMS_MACUTL.G_IDENTIFY_BY_FACTOR',
                 3,'DVSYS.DBMS_MACUTL.G_IDENTIFY_BY_CONTEXT',
                 4,'DVSYS.DBMS_MACUTL.G_IDENTIFY_BY_RULESET',
                 to_char(m.identified_by)),
         decode(m.labeled_by,
                 0,'DVSYS.DBMS_MACUTL.G_LABELED_BY_SELF',
                 1,'DVSYS.DBMS_MACUTL.G_LABELED_BY_FACTORS',
                 to_char(m.labeled_by)),
         decode(m.eval_options,
                 0,'DVSYS.DBMS_MACUTL.G_EVAL_ON_SESSION',
                 1,'DVSYS.DBMS_MACUTL.G_EVAL_ON_ACCESS',
                 2,'DVSYS.DBMS_MACUTL.G_EVAL_ON_STARTUP',
                 to_char(m.eval_options)),
         decode(m.audit_options,
                0,'DVSYS.DBMS_MACUTL.G_AUDIT_OFF',
                substr(
                  decode(bitand(m.audit_options,power(2,0)),
                        power(2,0),
                          ' || DVSYS.DBMS_MACUTL.G_AUDIT_ALWAYS',
                        0,'') ||
                  decode(bitand(m.audit_options,power(2,1)),
                        power(2,1),
                          ' || DVSYS.DBMS_MACUTL.G_AUDIT_ON_GET_ERROR',
                        0,'') ||
                  decode(bitand(m.audit_options,power(2,2)),
                        power(2,2),
                          ' || DVSYS.DBMS_MACUTL.G_AUDIT_ON_GET_NULL',
                        0,'') ||
                  decode(bitand(m.audit_options,power(2,3)),
                        power(2,3),
                          ' || DVSYS.DBMS_MACUTL.G_AUDIT_ON_VALIDATE_ERROR',
                        0,'') ||
                  decode(bitand(m.audit_options,power(2,4)),
                        power(2,4),
                          ' || DVSYS.DBMS_MACUTL.G_AUDIT_ON_VALIDATE_FALSE',
                        0,'') ||
                  decode(bitand(m.audit_options,power(2,5)),
                        power(2,5),
                          ' || DVSYS.DBMS_MACUTL.G_AUDIT_ON_TRUST_LEVEL_NULL',
                        0,'') ||
                  decode(bitand(m.audit_options,power(2,6)),
                        power(2,6),
                          ' || DVSYS.DBMS_MACUTL.G_AUDIT_ON_TRUST_LEVEL_NEG',
                        0,''), 5)),
         decode(m.fail_options,
                 1,'DVSYS.DBMS_MACUTL.G_FAIL_WITH_MESSAGE',
                 2,'DVSYS.DBMS_MACUTL.G_FAIL_SILENTLY',
                 to_char(m.fail_options))
   from dvsys.factor$         m,
        dvsys.factor_t$       d,
        dvsys.factor_type_t$  dft,
        dvsys.rule_set_t$     drs
  where m.id# = d.id#
    and dft.id# = m.factor_type_id#
    and drs.id#  (+)= m.assign_rule_set_id#
    and m.id# >= 5000
    and (SYS_CONTEXT('USERENV','CURRENT_USERID') = 1279990 OR
         EXISTS ( SELECT * FROM sys.session_roles
                  WHERE role='DV_OWNER' ))

View Text - HTML Formatted

SELECT '0'
, '0'
, M.NAME
, DFT.NAME
, D.DESCRIPTION
, D.LANGUAGE
, DRS.NAME
, M.GET_EXPR
, M.VALIDATE_EXPR
, DECODE(M.IDENTIFIED_BY
, 0
, 'DVSYS.DBMS_MACUTL.G_IDENTIFY_BY_CONSTANT'
, 1
, 'DVSYS.DBMS_MACUTL.G_IDENTIFY_BY_METHOD'
, 2
, 'DVSYS.DBMS_MACUTL.G_IDENTIFY_BY_FACTOR'
, 3
, 'DVSYS.DBMS_MACUTL.G_IDENTIFY_BY_CONTEXT'
, 4
, 'DVSYS.DBMS_MACUTL.G_IDENTIFY_BY_RULESET'
, TO_CHAR(M.IDENTIFIED_BY))
, DECODE(M.LABELED_BY
, 0
, 'DVSYS.DBMS_MACUTL.G_LABELED_BY_SELF'
, 1
, 'DVSYS.DBMS_MACUTL.G_LABELED_BY_FACTORS'
, TO_CHAR(M.LABELED_BY))
, DECODE(M.EVAL_OPTIONS
, 0
, 'DVSYS.DBMS_MACUTL.G_EVAL_ON_SESSION'
, 1
, 'DVSYS.DBMS_MACUTL.G_EVAL_ON_ACCESS'
, 2
, 'DVSYS.DBMS_MACUTL.G_EVAL_ON_STARTUP'
, TO_CHAR(M.EVAL_OPTIONS))
, DECODE(M.AUDIT_OPTIONS
, 0
, 'DVSYS.DBMS_MACUTL.G_AUDIT_OFF'
, SUBSTR( DECODE(BITAND(M.AUDIT_OPTIONS
, POWER(2
, 0))
, POWER(2
, 0)
, ' || DVSYS.DBMS_MACUTL.G_AUDIT_ALWAYS'
, 0
, '') || DECODE(BITAND(M.AUDIT_OPTIONS
, POWER(2
, 1))
, POWER(2
, 1)
, ' || DVSYS.DBMS_MACUTL.G_AUDIT_ON_GET_ERROR'
, 0
, '') || DECODE(BITAND(M.AUDIT_OPTIONS
, POWER(2
, 2))
, POWER(2
, 2)
, ' || DVSYS.DBMS_MACUTL.G_AUDIT_ON_GET_NULL'
, 0
, '') || DECODE(BITAND(M.AUDIT_OPTIONS
, POWER(2
, 3))
, POWER(2
, 3)
, ' || DVSYS.DBMS_MACUTL.G_AUDIT_ON_VALIDATE_ERROR'
, 0
, '') || DECODE(BITAND(M.AUDIT_OPTIONS
, POWER(2
, 4))
, POWER(2
, 4)
, ' || DVSYS.DBMS_MACUTL.G_AUDIT_ON_VALIDATE_FALSE'
, 0
, '') || DECODE(BITAND(M.AUDIT_OPTIONS
, POWER(2
, 5))
, POWER(2
, 5)
, ' || DVSYS.DBMS_MACUTL.G_AUDIT_ON_TRUST_LEVEL_NULL'
, 0
, '') || DECODE(BITAND(M.AUDIT_OPTIONS
, POWER(2
, 6))
, POWER(2
, 6)
, ' || DVSYS.DBMS_MACUTL.G_AUDIT_ON_TRUST_LEVEL_NEG'
, 0
, '')
, 5))
, DECODE(M.FAIL_OPTIONS
, 1
, 'DVSYS.DBMS_MACUTL.G_FAIL_WITH_MESSAGE'
, 2
, 'DVSYS.DBMS_MACUTL.G_FAIL_SILENTLY'
, TO_CHAR(M.FAIL_OPTIONS))
FROM DVSYS.FACTOR$ M
, DVSYS.FACTOR_T$ D
, DVSYS.FACTOR_TYPE_T$ DFT
, DVSYS.RULE_SET_T$ DRS
WHERE M.ID# = D.ID#
AND DFT.ID# = M.FACTOR_TYPE_ID#
AND DRS.ID# (+)= M.ASSIGN_RULE_SET_ID#
AND M.ID# >= 5000
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 1279990 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='DV_OWNER' ))