DBA Data[Home] [Help]

VIEW: SYS.KU$_XSINST_INH_VIEW

Source

View Text - Preformatted

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
View Text - HTML Formatted

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