Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle last user logon

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

PREVIOUS NEXT
Code Example
Sql :: create table in dbms cmds 
Sql :: sql case when exists in another table 
Sql :: database schema for mcqs type exam in sql 
Sql :: the primary key is selected from the 
Sql :: mysql start of today 
Sql :: postgres insert knex 
Sql :: oracle index hint multiple tables example 
Sql :: insert data 
Sql :: sql trigger 
Sql :: what is in operator 
Sql :: mysql select count if contains 
Sql :: java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed 
Sql :: how to open database 
Sql :: Data type and their numeric form 
Sql :: get month and year from date in mysql sequelize 
Sql :: tsql utf to local time 
Sql :: stored procedure to change name of column for all dependent tables and views 
Csharp :: create a directory if it doesnt exist c# 
Csharp :: unity create random string 
Csharp :: add only bottom border to container flutter 
Csharp :: c# list to string comma separated 
Csharp :: asp.net c# write string to text file 
Csharp :: unity check if number is multiple of x 
Csharp :: kotlin random number 
Csharp :: how get url in laravel 
Csharp :: loop through enum c# 
Csharp :: current directory in sln file c# 
Csharp :: how to delay execution in c# 
Csharp :: how to delete folder with files on c# 
Csharp :: random value in array c# 
ADD CONTENT
Topic
Content
Source link
Name
5+1 =