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






  1. Oracle PL / SQL
  2. System Tables Views
  3. DBA_AUDIT_SESSION

Query DBA_AUDIT_SESSION for Logoff time

 


SQL> select
  9    TO_CHAR(Logoff_Time,'DD-MON-YY HH24:MI:SS')   /*Logoff time*/
 10  from DBA_AUDIT_SESSION;
SQL>
SQL>








Related examples in the same category

1.Query DBA_AUDIT_SESSION for Login 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