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 vote345 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
0 vote317 views1 answer
Mariadb used space
SQL
2 votes337 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
6 votes332 views1 answer
Phpmyadmin password root
SQL
0 vote348 views1 answer
How to see password mysql vestacp
SQL
0 vote338 views1 answer
Hoq to import database source
SQL
0 vote338 views1 answer
Implicit inner join table alias
SQL
0 vote287 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
8 votes340 views1 answer
Sql limit results returned
SQL
4 votes338 views1 answer
Oracle error line
SQL