Oracle apex call duration

SELECT ELAPSED_TIME, numtodsinterval(ELAPSED_TIME, 'second') IV,
       extract(MINUTE FROM numtodsinterval(ELAPSED_TIME, 'second')) MI,
       extract(SECOND FROM numtodsinterval(ELAPSED_TIME, 'second')) SS
FROM APEX_WORKSPACE_ACTIVITY_LOG 
WHERE WORKSPACE = 'wks_name'
    AND APEX_USER = 'user_name'
    AND APPLICATION_ID = 'app_id';

Source: stackoverflow.com

Similar codes

0 vote141 views1 answer
Watch mysql command line
SQL
1 vote156 views1 answer
How to run parallel queries in sql server with entity framework
SQL
23 votes123 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote136 views1 answer
Create temporal table in sql
SQL
0 vote148 views1 answer
How to run mysql on terminal mac
SQL
10 votes149 views2 answers
Mysql drop database if exists
SQL
1 vote135 views1 answer
Oracle start job
SQL
0 vote156 views1 answer
SQL Server date literal
SQL
22 votes137 views4 answers
Show list of users in mysql
SQL
0 vote150 views1 answer
Casterar postgres
SQL