DBA Data[Home] [Help]

VIEW: SYS.KU$_XSINST_RULE_VIEW

Source

View Text - Preformatted

select '1','0',
  i.xdsid#,
  i.order#,
  REPLACE(i.rule, '''', ''''''),
  i.static,
  i.flags,
  i.description,
  (cast(multiset(select value(a)
                 from ku$_xsinst_acl_view a
                 where a.xdsid= i.xdsid# and a.order_num = i.order#)
                 as ku$_xsinstacl_list_t))
  from xs$instset_rule i
View Text - HTML Formatted

SELECT '1'
, '0'
, I.XDSID#
, I.ORDER#
, REPLACE(I.RULE
, ''''
, '''''')
, I.STATIC
, I.FLAGS
, I.DESCRIPTION
, (CAST(MULTISET(SELECT VALUE(A)
FROM KU$_XSINST_ACL_VIEW A
WHERE A.XDSID= I.XDSID#
AND A.ORDER_NUM = I.ORDER#) AS KU$_XSINSTACL_LIST_T))
FROM XS$INSTSET_RULE I