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 vote207 views1 answer
Sparql list all graphs
SQL
1 vote186 views1 answer
How to start with sql
SQL
-1 vote210 views1 answer
Module operator in oracle sql
SQL
0 vote203 views1 answer
Trigger vérifier stock
SQL
32 votes210 views6 answers
How to change column name in sql
SQL
1 vote200 views2 answers
Oracle list service names
SQL
0 vote195 views1 answer
On update current_timestamp jpa
SQL
1 vote191 views1 answer
T-sql find object by name
SQL
0 vote181 views2 answers
Get top 1 row of each group
SQL
6 votes182 views2 answers
Mysql version check cmd
SQL