select '1','0',
i.xdsid#,
i.order#,
i.parent_schema,
i.parent_object,
i.when,
(cast(multiset(select value(a)
from ku$_xsinst_inhkey_view a
where a.xdsid= i.xdsid# and a.order_num = i.order#)
as ku$_xsinstinhkey_list_t))
from xs$instset_inh i
SELECT '1'
, '0'
,
I.XDSID#
,
I.ORDER#
,
I.PARENT_SCHEMA
,
I.PARENT_OBJECT
,
I.WHEN
,
(CAST(MULTISET(SELECT VALUE(A)
FROM KU$_XSINST_INHKEY_VIEW A
WHERE A.XDSID= I.XDSID#
AND A.ORDER_NUM = I.ORDER#)
AS KU$_XSINSTINHKEY_LIST_T))
FROM XS$INSTSET_INH I
|
|
|