select name, status, account_status, lock_date, expiry_date,
direct_logon_user, description
from dba_xs_users
where name = xs_sys_context('XS$SESSION','CURRENT_XS_USER')
View Text - HTML Formatted
SELECT NAME , STATUS , ACCOUNT_STATUS , LOCK_DATE , EXPIRY_DATE ,
DIRECT_LOGON_USER , DESCRIPTION
FROM DBA_XS_USERS
WHERE NAME = XS_SYS_CONTEXT('XS$SESSION' , 'CURRENT_XS_USER')