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

11 votes188 views2 answers
You are using safe update mode
SQL
0 vote186 views1 answer
Create database like
SQL
0 vote183 views1 answer
Sauvegarde complète my sql
SQL
3 votes221 views1 answer
Oracle nextval insert
SQL
0 vote191 views1 answer
Sql datediff db2
SQL
0 vote188 views1 answer
How to drop a trigger in postgresql
SQL
0 vote272 views1 answer
Compare strings lexicographically in sql
SQL
0 vote188 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
1 vote205 views1 answer
Oracle sql pad left zeros
SQL
3 votes168 views3 answers
Mysql select table names
SQL