Oracle 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

0 vote180 views2 answers
Find Overlapping sql
SQL
25 votes177 views4 answers
Metadata
SQL
0 vote186 views1 answer
Mysql date time string format python
SQL
0 vote190 views1 answer
Mysql procedure between two tables
SQL
1 vote192 views1 answer
Increase existing date in sql oracle
SQL
-1 vote186 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
3 votes205 views2 answers
Sql end of month
SQL
2 votes192 views1 answer
Datetrunc
SQL
9 votes198 views4 answers
Postgresql export database
SQL
0 vote195 views1 answer
Jdbc sql connection string
SQL