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

1 vote104 views1 answer
Crontab every month
SQL
0 vote106 views1 answer
Mysql cli output to a file
SQL
0 vote105 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote106 views1 answer
Compare subqueries oracle
SQL
4 votes113 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote105 views1 answer
Sql server set complex constraints
SQL
1 vote105 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote134 views1 answer
Bash block size ls /var/lib/mysql
SQL
1 vote105 views1 answer
Pl sql create table from another table
SQL
3 votes216 views6 answers
Sql unique select
SQL