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 vote183 views1 answer
Oracle get running queries
SQL
3 votes181 views5 answers
Mysql get last inserted id
SQL
-1 vote191 views1 answer
Add bool column in sql
SQL
21 votes197 views4 answers
Add column mssql
SQL
0 vote249 views1 answer
Get first monday of month sql
SQL
0 vote186 views1 answer
Guid string to binary better
SQL
3 votes230 views2 answers
Update part of a string in mysql
SQL
0 vote130 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote210 views1 answer
Error code 1451 sql
SQL
2 votes189 views1 answer
Oracle to_char number format percentage
SQL