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

3 votes298 views1 answer
Créer une table sql
SQL
0 vote311 views1 answer
Typeorm raw sql
SQL
0 vote311 views1 answer
Openquery join two tables
SQL
0 vote318 views1 answer
Select sql in descending order
SQL
0 vote240 views1 answer
Mysql collation for all languages
SQL
0 vote284 views1 answer
Sql track modification
SQL
1 vote289 views1 answer
How to get mysql db size
SQL
1 vote294 views1 answer
Mysql month name extract
SQL
0 vote292 views1 answer
Oracle exchange partition
SQL
0 vote292 views2 answers
Oracle create chain rule
SQL