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
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
|
|
|