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 vote338 views1 answer
Show tables in cassandra cql
SQL
6 votes321 views1 answer
Oracle list primary key
SQL
0 vote308 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
2 votes327 views2 answers
How to check database username and password in postgresql
SQL
0 vote278 views1 answer
Get only first row mysql
SQL
2 votes319 views2 answers
Mysql limit
SQL
11 votes287 views1 answer
Reset identity sql server
SQL
0 vote303 views1 answer
Mysqlimport
SQL
0 vote320 views2 answers
Plsql regex match whole word
SQL
3 votes311 views1 answer
Define REGEXP?
SQL