APEX elapsed time

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

2 votes159 views1 answer
Mysql change data type of column
SQL
0 vote171 views1 answer
Leftjoin in sql
SQL
0 vote139 views1 answer
In mysql workbench contnent not feching
SQL
0 vote162 views1 answer
Look at running processes redshift
SQL
0 vote186 views1 answer
Oracle current date minus 1 day
SQL
0 vote154 views2 answers
How to count codition
SQL
0 vote154 views1 answer
Flush user resource mysql
SQL
0 vote150 views1 answer
Can we rollback in sql
SQL
-1 vote167 views1 answer
Mysql extract days
SQL
1 vote166 views1 answer
How to get previous year from sysdate in oracle
SQL