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 vote250 views1 answer
Mysql date without time
SQL
3 votes224 views3 answers
Start postgresql ubuntu
SQL
0 vote226 views1 answer
Get sum sqlite android
SQL
0 vote212 views1 answer
Drop constraint in ms sql
SQL
0 vote206 views1 answer
Add column in sql server ubuntu
SQL
1 vote210 views2 answers
Oracle list partitioned tables
SQL
0 vote218 views1 answer
If column value is null then in mysql
SQL
0 vote210 views1 answer
Postgres sql alter table delete row
SQL
0 vote210 views1 answer
Sql select min
SQL
0 vote210 views1 answer
Sql get guid
SQL