Sql

SELECT max(TIMESTAMP), A.USERNAME
FROM DBA_AUDIT_TRAIL A
WHERE ACTION_NAME = 'LOGON'
GROUP BY USERNAME
ORDER BY 1 DESC;

PREVIOUS	NEXT

Code Example
Sql :: sql between date range
Sql :: mysql import gz
Sql :: add primary key constraint in oracle
Sql :: tsql update datetime
Sql :: mysql import gzip db
Sql :: oracle list dblink
Sql :: PLS-00225 type
Sql :: change varchar length mysql
Sql :: how to check all scheduled jobs in oracle
Sql :: postgresql select all column names
Sql :: how to get all table names in sql query
Sql :: group_concat limit mysql
Sql :: postgresql alter column nullable
Sql :: update mysql centos
Sql :: mysql remove last empty newline
Sql :: Starting mysql shell lampp ubuntu
Sql :: having count greater than 1 mysql
Sql :: check database size in mysql
Sql :: console output pl sql
Sql :: sql set auto increment back to 0
Sql :: query any digits record
Sql :: cursor in sql server
Sql :: oracle session date format
Sql :: group by mysql and concatenate string
Sql :: sql join exists
Sql :: display total number of tables in mysql
Sql :: ALL_TAB_PARTITIONS
Sql :: date_add mysql
Sql :: update set with inner join oracle
Sql :: sql replace null with 0