VIEW: SYS.DBA_XS_REALM_CONSTRAINTS

Source

View Text - Preformatted

select o1.name, o1.owner, il.order#,
       decode(il.type,
              1, decode(bitand(ir.flags, 1), 0, 'REGULAR', 'PARAMETERIZED'),
              'INHERITED'),
       decode(ir.static, 1, 'STATIC ', 'DYNAMIC'),
       decode(il.type, 1, ir.rule, null),
       ir.description,
       acl.name, acl.owner, ih.parent_object, ih.parent_schema
  from sys.xs$instset_list il,
       sys.xs$instset_rule ir,
       sys.xs$instset_inh  ih,
       (select ia.xdsid#, ia.order#, o2.name, o2.owner
          from sys.xs$instset_acl  ia, sys.xs$obj o2
         where ia.acl# = o2.id) acl,
       sys.xs$obj o1
 where il.xdsid# = ir.xdsid#(+)  and
       il.order# = ir.order#(+)  and
       il.xdsid# = acl.xdsid#(+) and
       il.order# = acl.order#(+) and
       il.xdsid# = ih.xdsid#(+)  and
       il.order# = ih.order#(+)  and
       il.xdsid# = o1.id

View Text - HTML Formatted

SELECT O1.NAME
, O1.OWNER
, IL.ORDER#
, DECODE(IL.TYPE
, 1
, DECODE(BITAND(IR.FLAGS
, 1)
, 0
, 'REGULAR'
, 'PARAMETERIZED')
, 'INHERITED')
, DECODE(IR.STATIC
, 1
, 'STATIC '
, 'DYNAMIC')
, DECODE(IL.TYPE
, 1
, IR.RULE
, NULL)
, IR.DESCRIPTION
, ACL.NAME
, ACL.OWNER
, IH.PARENT_OBJECT
, IH.PARENT_SCHEMA
FROM SYS.XS$INSTSET_LIST IL
, SYS.XS$INSTSET_RULE IR
, SYS.XS$INSTSET_INH IH
, (SELECT IA.XDSID#
, IA.ORDER#
, O2.NAME
, O2.OWNER
FROM SYS.XS$INSTSET_ACL IA
, SYS.XS$OBJ O2
WHERE IA.ACL# = O2.ID) ACL
, SYS.XS$OBJ O1
WHERE IL.XDSID# = IR.XDSID#(+) AND IL.ORDER# = IR.ORDER#(+) AND IL.XDSID# = ACL.XDSID#(+) AND IL.ORDER# = ACL.ORDER#(+) AND IL.XDSID# = IH.XDSID#(+) AND IL.ORDER# = IH.ORDER#(+) AND IL.XDSID# = O1.ID