Oracle中找出用户的上次登录时间
可以使用如下sql语句:
select t1.username,t1.logon_time last_logon_time,t2.account_status,created 账号创建时间 from (select username,max(timestamp) logon_time from dba_audit_session where action_name='LOGON' and username in (select username from dba_users) group by username) t1 left join (select username,account_status,created from dba_users) t2 on t2.username=t1.username
以上
啦啦啦!!!