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 vote123 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
12 votes126 views4 answers
Mysql version query
SQL
5 votes159 views2 answers
Functions
SQL
0 vote119 views2 answers
Oracle create tablespace autoextend
SQL
0 vote131 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote130 views1 answer
Two inner joins sql
SQL
0 vote124 views2 answers
Check mysql timezone
SQL
0 vote154 views1 answer
Sql to excel pgadmin
SQL
0 vote145 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
1 vote123 views3 answers
Get all tables postgres
SQL