sql query to find last login date oracle

sql query to find last login date oracle

In this post , We will be discuss about sql query to find last login date oracle. Using this sql query , we will be able to find that , when the users have last login the oracle database and the oracle application. There are different sql query to find last login date for both oracle and application. To find out the Database last login date we need to refer the dba_users table in oracle. Here below is the detail about sql query to find last login date oracle.

2 Important sql query to find last login date oracle

To find the last login date for Oracle Database users , we need to refer this below sql query.

select
   username,
   last_login
from
   dba_users
order by
   username';

To find the last login date for Oracle Application users , we need to refer this below sql query.

select
   username,
   last_login_date
from
   fnd_user
order by
   username';