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 vote294 views2 answers
Start mysql server using docker
SQL
0 vote229 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote266 views1 answer
Using distinct and count together in sql
SQL
3 votes249 views1 answer
Pl sql check if variable is empty
SQL
2 votes249 views1 answer
Sql find missing values between two tables
SQL
2 votes321 views2 answers
Set value to null sql
SQL
8 votes269 views1 answer
Show mysql user table
SQL
0 vote278 views1 answer
Print hello world in plsql
SQL
0 vote271 views1 answer
Run mssql server terminal
SQL
-1 vote320 views4 answers
Full outer join in sql
SQL