Oracle apex call duration

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 vote186 views1 answer
Oracle list user locked
SQL
0 vote157 views1 answer
Sqlite referential integrity
SQL
0 vote144 views1 answer
Opensuse stop MySQL
SQL
1 vote170 views1 answer
Round one decimal place mysql
SQL
2 votes172 views1 answer
Oracle current date without time
SQL
7 votes166 views3 answers
SQL create a new table
SQL
4 votes230 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
1 vote142 views1 answer
Use of now() in mysql
SQL
0 vote223 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote141 views1 answer
Inser into example
SQL