DBA Data[Home] [Help]

VIEW: SYS.EXU8PHS

Source

View Text - Preformatted

SELECT  h.user#, u.name, h.password,
                to_char(h.password_date,'YYYY-MM-DD HH24:MI:SS')
        FROM    sys.user_history$ h, sys.user$ u
        WHERE   h.user# = u.user#
View Text - HTML Formatted

SELECT H.USER#
, U.NAME
, H.PASSWORD
, TO_CHAR(H.PASSWORD_DATE
, 'YYYY-MM-DD HH24:MI:SS')
FROM SYS.USER_HISTORY$ H
, SYS.USER$ U
WHERE H.USER# = U.USER#