Oracle run_duration to number

SELECT JOB_NAME,
       avg(extract(DAY FROM run_duration) * 24 * 60 * 60
               + extract(HOUR FROM run_duration) * 60 * 60
               + extract(MINUTE FROM run_duration) * 60
               + extract(SECOND FROM run_duration))
FROM DBA_SCHEDULER_JOB_RUN_DETAILS
WHERE JOB_NAME = 'my_job_name'
GROUP BY JOB_NAME;

Source: thatjeffsmith.com

Similar codes

50 votes366 views6 answers
Install mysql on ubuntu
SQL
0 vote299 views2 answers
How to set global time_zone in mysql
SQL
2 votes325 views2 answers
Postgresql get table names
SQL
3 votes316 views1 answer
Postgres select max value
SQL
2 votes303 views3 answers
Current setting postgres timezone
SQL
4 votes321 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
1 vote282 views1 answer
Delete mysql from mac
SQL
0 vote303 views1 answer
Database xml sql
SQL
0 vote308 views2 answers
Greater than sql server
SQL
0 vote292 views1 answer
Sql select rows with different values in one column
SQL