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

21 votes322 views3 answers
Average sql
SQL
0 vote305 views1 answer
Strat with in sql
SQL
2 votes359 views1 answer
Mysql trigger after update
SQL
4 votes324 views3 answers
Mysql update with join
SQL
11 votes343 views2 answers
Mysql set safe mode off
SQL
0 vote340 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote328 views1 answer
Count characters of string mysql
SQL
10 votes372 views4 answers
Mysql if else
SQL
3 votes419 views4 answers
Sql interview questions
SQL
0 vote348 views1 answer
Execute sql stored procedure in powershell
SQL