Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle user last connection date

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

PREVIOUS NEXT
Code Example
Sql :: how to run mysql in git bash 
Sql :: check if mysql is installed 
Sql :: revokeprivileges mysql 
Sql :: mysql delete row 
Sql :: find a column in all tables postgres 
Sql :: oracle drop column 
Sql :: status mysql 
Sql :: syntax for changing column size in mysql 
Sql :: append column sql 
Sql :: install mysql server linux 
Sql :: how to list function in psql 
Sql :: oracle sleep 
Sql :: second last highest id in sql 
Sql :: oracle extract minute from date 
Sql :: drop column if exists sql server 
Sql :: mysql password error create datbase 
Sql :: oracle list invalid password logon denied 
Sql :: check database size sql 
Sql :: mysql date - 1 day 
Sql :: oracle current date 
Sql :: pop sql insert value into 
Sql :: bigquery get current date 
Sql :: oracle set date format 
Sql :: postgresql get last day of month 
Sql :: mqtt Error: Address not available 
Sql :: sql week commencing date 
Sql :: mysql substract count and distinct count 
Sql :: NOT LIKE sql laravel 
Sql :: postgresql group by month and year 
Sql :: oracle character set 
ADD CONTENT
Topic
Content
Source link
Name
4+4 =