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

2 votes158 views1 answer
Mariadb select multiple rows into one column
SQL
11 votes161 views2 answers
Sql rank
SQL
1 vote136 views1 answer
Sql auto timestamp
SQL
1 vote151 views1 answer
Oracle apex run 404
SQL
0 vote205 views1 answer
Tsql find procedure with name
SQL
0 vote140 views1 answer
Postgres call view
SQL
2 votes218 views1 answer
Tsql copy table
SQL
0 vote126 views0 answer
SQL
0 vote131 views1 answer
Output to file mysql
SQL
2 votes154 views1 answer
How to get weekday from old date in sql
SQL