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 vote330 views3 answers
Psql fatal database does not exist
SQL
1 vote347 views1 answer
How to start with sql
SQL
1 vote362 views1 answer
Tsql update datetime
SQL
3 votes354 views1 answer
Sql insert inserted id
SQL
4 votes334 views1 answer
Oracle table statistics last analyzed
SQL
0 vote327 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote337 views1 answer
Get employees if not contains in sql
SQL
3 votes338 views2 answers
Df to sql pandas sql achemy
SQL
3 votes371 views2 answers
How to force truncate a table in mysql
SQL
2 votes333 views3 answers
3 days back in sql server
SQL