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

1 vote406 views2 answers
Drop table with constraints
SQL
0 vote344 views1 answer
Except in sql
SQL
0 vote360 views1 answer
Sqlite3 update select
SQL
1 vote364 views1 answer
How to fetch alternate records from two tables
SQL
2 votes369 views1 answer
Orcale index size
SQL
23 votes369 views6 answers
How to create table in sql
SQL
0 vote379 views1 answer
Query builder doctrien return sql
SQL
0 vote357 views1 answer
Mysql change innodb to myisam
SQL
8 votes363 views1 answer
Today minus 15 days postgresql
SQL
0 vote455 views1 answer
Sp help text in postgresql
SQL