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 vote268 views1 answer
Oracle sql listagg
SQL
0 vote285 views1 answer
Sql injection payload list github
SQL
0 vote282 views1 answer
How to find lowest in sql
SQL
0 vote282 views1 answer
Mysql 8 geo to json
SQL
3 votes283 views1 answer
Sql add two values together
SQL
0 vote259 views1 answer
Sqlite update only if greater
SQL
1 vote291 views1 answer
Get current date in pyspark sql
SQL
1 vote276 views3 answers
What is union in sql
SQL
0 vote278 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
4 votes256 views1 answer
Oracle error compilation line
SQL