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

2 votes101 views1 answer
Mysql find tables with name
SQL
0 vote99 views1 answer
Export partttion and import in oracle
SQL
0 vote100 views1 answer
How to find symmetric pairs in sql
SQL
0 vote112 views1 answer
Access mysql database docker container shell
SQL
0 vote110 views1 answer
Check psql validity function
SQL
0 vote106 views1 answer
Sql create text column limited values
SQL
0 vote109 views1 answer
Renommer table sql
SQL
0 vote126 views2 answers
How to install psql in ubuntu
SQL
0 vote109 views1 answer
Oracle exchange subpartition
SQL
0 vote111 views1 answer
Start and stop mysql
SQL