select ubv.*,
cast(multiset(select * from ku$_user_editioning_view uev
where uev.user_id = ubv.user_id)
as ku$_user_editioning_list_t)
from sys.ku$_user_base_view ubv
SELECT UBV.*
,
CAST(MULTISET(SELECT *
FROM KU$_USER_EDITIONING_VIEW UEV
WHERE UEV.USER_ID = UBV.USER_ID)
AS KU$_USER_EDITIONING_LIST_T)
FROM SYS.KU$_USER_BASE_VIEW UBV
|
|
|