Query DBA_AUDIT_SESSION for Login time : DBA_AUDIT_SESSION « System Tables Views « Oracle PL / SQL






Query DBA_AUDIT_SESSION for Login time

 
SQL> select
  8    TO_CHAR(Timestamp,'DD-MON-YY HH24:MI:SS')    /*Login time*/
 10  from DBA_AUDIT_SESSION;
SQL>
SQL>

   
  








Related examples in the same category

1.Query DBA_AUDIT_SESSION for Logoff time
2.Query DBA_AUDIT_SESSION for Operating system username used
3.Query DBA_AUDIT_SESSION for Oracle username of the account used
4.Query DBA_AUDIT_SESSION for Terminal ID used