DBA Data[Home] [Help]

VIEW: SYS.KU$_USER_VIEW

Source

View Text - Preformatted

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

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