Oracle run_duration average

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

4 votes110 views2 answers
Sql select except null
SQL
1 vote130 views1 answer
Isnull sql server
SQL
0 vote121 views1 answer
Sql delete row from table where id
SQL
0 vote114 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote120 views1 answer
Table user postgres
SQL
0 vote147 views1 answer
Sql int vs integer
SQL
0 vote116 views1 answer
How to find all children of a record with only parent ID in sql
SQL
1 vote129 views2 answers
Postgresql remote connect
SQL
0 vote109 views1 answer
Mssql now diff 90 day
SQL
1 vote68 views1 answer
Python escape string for sql
SQL