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 vote189 views1 answer
Mysql workbench procedure
SQL
3 votes204 views2 answers
Mysql select database
SQL
0 vote286 views1 answer
Site:av.ru "files"
SQL
0 vote173 views1 answer
Call function sql oracle
SQL
0 vote180 views1 answer
Xampp increame mysql speed
SQL
0 vote176 views1 answer
Inserting data into different tables at once in oracle sql
SQL
2 votes200 views1 answer
Oracle list duplicates
SQL
7 votes260 views2 answers
Oracle foreign key reference table
SQL
0 vote168 views1 answer
Sql menampilkan data tabel
SQL
0 vote176 views1 answer
Set column in all row mysql
SQL