/SQL/Oracle convert run_duration to number

Oracle convert 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 vote208 views1 answer
Power bi union columns
SQL
5 votes175 views2 answers
Oracle list columns schema
SQL
0 vote221 views1 answer
Mysql insert into select transaction c#
SQL
1 vote194 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
3 votes190 views2 answers
Oracle grants
SQL
2 votes209 views2 answers
How to run postgresql in linux
SQL
2 votes205 views1 answer
Oracle percentage
SQL
0 vote228 views1 answer
Stratified sampling sql
SQL
2 votes193 views3 answers
Current month mysql query
SQL
1 vote208 views1 answer
Mysql count all table rows
SQL