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

5 votes145 views1 answer
Minecraft java port number
SQL
0 vote161 views1 answer
Get date ISO in psql
SQL
-1 vote187 views1 answer
Partial search in sql
SQL
0 vote159 views1 answer
How to get first 10 records of a table in mysql
SQL
2 votes146 views2 answers
Get all tables using like
SQL
0 vote139 views1 answer
Sqlite to csv statement
SQL
1 vote99 views1 answer
Full text index mysql
SQL
0 vote153 views1 answer
Mysql filter based on datediff
SQL
0 vote145 views1 answer
Transaction database with php
SQL
1 vote171 views1 answer
Postgres see sequence current state
SQL