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

10 votes319 views1 answer
Oracle dependency
SQL
2 votes339 views2 answers
Laravel query builder toSql
SQL
37 votes360 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote358 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote345 views2 answers
Getting customers with no orders sql
SQL
0 vote336 views1 answer
Mysql workbench not showing schemas
SQL
4 votes339 views3 answers
Count with where
SQL
2 votes340 views2 answers
Sqlite_busy: database is locked
SQL
0 vote366 views1 answer
Oracle array
SQL
2 votes380 views1 answer
How to select from mssql
SQL