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 vote139 views1 answer
Play framework connection via windows sql server
SQL
1 vote145 views1 answer
Oracle apex version view
SQL
1 vote81 views1 answer
Convert money to varchar sql server
SQL
0 vote132 views1 answer
Microsoft sql server python connection
SQL
0 vote138 views1 answer
Get enginge db mysql
SQL
0 vote112 views1 answer
Clone table structure mysql
SQL
10 votes142 views2 answers
Select nextval from sequence oracle
SQL
1 vote117 views1 answer
Mysql login console
SQL
0 vote76 views1 answer
Mysql date + 1 day
SQL
0 vote159 views1 answer
Sql multiple into
SQL