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 vote312 views1 answer
Mysql show category once count how many products
SQL
0 vote310 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
3 votes306 views2 answers
Mysql create database
SQL
0 vote309 views3 answers
Joins and views sql
SQL
6 votes317 views2 answers
How to copy data in sql
SQL
0 vote328 views1 answer
Copying query result to excel
SQL
0 vote382 views1 answer
Redshift running queries
SQL
0 vote275 views1 answer
Create duplicate table in postgresql
SQL
4 votes320 views1 answer
Id increment ms sql server
SQL
0 vote316 views1 answer
Oracle query archive mode
SQL