VIEW: SYS.KU$_11_2_PSW_HIST_VIEW

Source

View Text - Preformatted

select '1','0', u.user#, u.name,
         cast(multiset (select * from  ku$_psw_hist_list_view p
                where p.user_id = u.user# and
                      length(p.password) < 31) as  ku$_psw_hist_list_t)
  from sys.user$ u
  where exists (select 1 from sys.user_history$ h where h.user# = u.user#)

View Text - HTML Formatted

SELECT '1'
, '0'
, U.USER#
, U.NAME
, CAST(MULTISET (SELECT *
FROM KU$_PSW_HIST_LIST_VIEW P
WHERE P.USER_ID = U.USER# AND LENGTH(P.PASSWORD) < 31) AS KU$_PSW_HIST_LIST_T)
FROM SYS.USER$ U
WHERE EXISTS (SELECT 1
FROM SYS.USER_HISTORY$ H
WHERE H.USER# = U.USER#)