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

2 votes203 views1 answer
Sql OR
SQL
0 vote187 views1 answer
No suitable driver found for sqlite
SQL
4 votes174 views1 answer
Oracle show error line number
SQL
0 vote199 views1 answer
Update and keep original value sql
SQL
0 vote242 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote200 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
8 votes221 views1 answer
Oracle add auto_increment column to existing table
SQL
3 votes191 views2 answers
Oracle grants
SQL
0 vote189 views1 answer
What is the use of index in mysql table
SQL
0 vote214 views1 answer
Mysql bind-address default value
SQL