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

1 vote254 views1 answer
Select 2 rows in sql
SQL
1 vote281 views1 answer
Increase existing date in sql
SQL
2 votes250 views1 answer
Sql get the name of user pc
SQL
1 vote263 views1 answer
How to update date add hours in postgresql
SQL
0 vote254 views1 answer
Mysql update from n to 100
SQL
0 vote274 views3 answers
How to run sql query
SQL
0 vote264 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote275 views1 answer
Doesn't have default value mysql
SQL
0 vote272 views1 answer
Sql filter rows with condition
SQL
10 votes244 views1 answer
Dba_dependencies
SQL