Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>