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

1 vote164 views1 answer
Ms sql how to see active job current run time
SQL
2 votes210 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote209 views1 answer
Connecting mySQL to STS
SQL
0 vote203 views2 answers
Postgresql display subquery as json
SQL
38 votes204 views4 answers
Count sql
SQL
1 vote206 views2 answers
Last working day in week date function in sql
SQL
0 vote210 views1 answer
Sql alter column name sql server
SQL
1 vote194 views1 answer
Select statement to print longest name
SQL
2 votes172 views1 answer
Foreign key example in dbms
SQL
6 votes204 views1 answer
Phpmyadmin password root
SQL