Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>