Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle last connexion

SELECT a.USERNAME, max(TIMESTAMP) FROM DBA_AUDIT_TRAIL a
WHERE ACTION_NAME = 'LOGON' AND USERNAME IN ('MY_USER')
GROUP BY USERNAME ORDER BY 1;
Comment

PREVIOUS NEXT
Code Example
Sql :: find all tables where column name exists oracle 
Sql :: unique sql 
Sql :: how to check last index rebuild sql server 
Sql :: sql not equal to operator 
Sql :: create postgres role and database for bitbucket 
Sql :: fetlife 
Sql :: what is truncate in sql 
Sql :: mysql get 2nd value in comma separated list 
Sql :: python sqlalchemy orm to select null values 
Sql :: how to average max mysql 
Sql :: postgres show table schema 
Sql :: show sql property syntax for jpa. 
Sql :: List all the items that have not been part of any purchase order. sql 
Sql :: SQL Copy From Two Tables to One 
Sql :: left join sql 
Sql :: sql insert into select statement 
Sql :: sql where clause 
Sql :: sql server get date of previous sunday 
Sql :: Truncate a table then insert data 
Sql :: mysql workbench change default value 
Sql :: REMOVE DATE FROM DATE TIME SQL SERVER 
Sql :: cte in sql server 
Sql :: mysql allow connection from any host 
Sql :: MySQL error code 2068 
Sql :: sql recherche nom prenom 
Sql :: mql4 sleep 
Sql :: cannot connect to mysql server 10060 
Sql :: postgresql add not null and not empty constraint 
Sql :: mysql workbench primary key 
Sql :: les jointures sql server 
ADD CONTENT
Topic
Content
Source link
Name
3+1 =