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

22 votes135 views4 answers
Show list of users in mysql
SQL
0 vote132 views1 answer
How to move a columns location in mysql
SQL
15 votes162 views4 answers
Mysql export database command line
SQL
0 vote141 views1 answer
Search starting with mysql
SQL
1 vote133 views1 answer
Create temporal table in sql
SQL
0 vote140 views1 answer
Storing RGBA in mysql db
SQL
6 votes130 views1 answer
Oracle trigger after connect
SQL
0 vote148 views1 answer
Google cloud sql postgres url example
SQL
1 vote151 views1 answer
Set statiscis on in sql server
SQL
0 vote130 views1 answer
C# mysql data reader from two tables
SQL