Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle apex list connected users

SELECT *
FROM APEX_WORKSPACE_LOG_SUMMARY_USR
WHERE WORKSPACE = 'workspace_name'
  AND APEX_USER != 'nobody'
  AND LAST_VIEW >= trunc(sysdate);
Comment

PREVIOUS NEXT
Code Example
Sql :: create column mysql terminal 
Sql :: display total number of tables in mysql 
Sql :: sql update query 
Sql :: convert uniqueidentifier to varchar in sql 
Sql :: search query in mysql 
Sql :: sql random decimal 
Sql :: ALL_TAB_PARTITIONS 
Sql :: how to get table structure in sql server 
Sql :: postgresql if null then 0 
Sql :: date_add mysql 
Sql :: oracle stop 
Sql :: drop table in mysql 
Sql :: sql query inline if 
Sql :: postgres list tables and row counts 
Sql :: SQL query to convert DD/MM/YYYY to YYYY-MM-DD 
Sql :: add timestamp column to existing table ms sql server 
Sql :: alter table in mysql 
Sql :: mysql time ago difference 
Sql :: ora-00054 resource busy and acquire with nowait 
Sql :: sql if null then 0 
Sql :: wsl centos 8 mysql 
Sql :: cmd to rename a collumn name in sql 
Sql :: sql rename column 
Sql :: How to get todays date and current time in mysql 
Sql :: postgresql substring 
Sql :: purge undo tablespace usage 
Sql :: postgresql list users 
Sql :: postgresql drop table 
Sql :: opensuse restart MySQL 
Sql :: mysql check if not null 
ADD CONTENT
Topic
Content
Source link
Name
3+6 =