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

0 vote357 views1 answer
How to find username and password in oracle 18c
SQL
1 vote359 views1 answer
Postgresql delete cascade
SQL
10 votes428 views6 answers
Mysql set root password
SQL
0 vote356 views1 answer
Import big data to mysql
SQL
0 vote349 views1 answer
Select password from user mysql
SQL
3 votes368 views3 answers
Order by postgres
SQL
0 vote361 views1 answer
18446744073709551615 mariadb left join order by
SQL
12 votes349 views4 answers
Mysql version query
SQL
3 votes378 views1 answer
Postgresql today - 1 year
SQL
5 votes393 views4 answers
Upload database mysql command line
SQL