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

4 votes335 views1 answer
Data types in sql
SQL
0 vote327 views1 answer
Oracle date winter time
SQL
1 vote326 views3 answers
How to filter repeated same result using sql query
SQL
0 vote411 views1 answer
How to rename a database in tsql
SQL
1 vote318 views1 answer
SQL date part only of datetime
SQL
0 vote311 views1 answer
Knex last insert id mysql
SQL
0 vote299 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote315 views1 answer
Mysql workbench view
SQL
35 votes365 views5 answers
Sql alter column
SQL
0 vote313 views1 answer
Mysql dump everythign
SQL