select '1','0',
i.xdsid#,
i.order#,
i.type,
(select value(r) from ku$_xsinst_rule_view r
where r.xdsid= i.xdsid# and r.order_num = i.order#),
(cast(multiset(select value(a)
from ku$_xsinst_inh_view a
where a.xdsid= i.xdsid# and a.order_num = i.order#)
as ku$_xsinstinh_list_t))
from xs$instset_list i
SELECT '1'
, '0'
,
I.XDSID#
,
I.ORDER#
,
I.TYPE
,
(SELECT VALUE(R)
FROM KU$_XSINST_RULE_VIEW R
WHERE R.XDSID= I.XDSID#
AND R.ORDER_NUM = I.ORDER#)
,
(CAST(MULTISET(SELECT VALUE(A)
FROM KU$_XSINST_INH_VIEW A
WHERE A.XDSID= I.XDSID#
AND A.ORDER_NUM = I.ORDER#)
AS KU$_XSINSTINH_LIST_T))
FROM XS$INSTSET_LIST I
|
|
|