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

1 vote109 views1 answer
Mysql show current queries
SQL
0 vote117 views1 answer
T-sql update table variale
SQL
0 vote243 views1 answer
Generate a random otp in sql server
SQL
0 vote165 views1 answer
Get last inserted primary key
SQL
0 vote117 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
5 votes132 views3 answers
Sql server utc to local
SQL
3 votes123 views2 answers
MySQL query to get column names
SQL
0 vote107 views1 answer
Sql random decimal
SQL
0 vote113 views1 answer
Mysql select all table that have field names
SQL
0 vote120 views1 answer
Sqlplus change user
SQL