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

4 votes236 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 vote225 views1 answer
Sql declare variable single line
SQL
1 vote185 views1 answer
Python escape string for sql
SQL
0 vote212 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote206 views1 answer
Remove from table where
SQL
0 vote215 views1 answer
Database xml sql
SQL
0 vote249 views1 answer
Add super privilege mysql
SQL
0 vote213 views1 answer
Sql waitfor
SQL
0 vote212 views1 answer
View psql output in horizontal scrolling
SQL
1 vote220 views1 answer
Postgres check for foreign key
SQL