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 vote291 views2 answers
Show sql logs in spring boot
SQL
1 vote334 views1 answer
How to make a select in sql
SQL
1 vote346 views1 answer
Mysql query where in select
SQL
2 votes313 views1 answer
Username sql
SQL
0 vote336 views3 answers
Joins and views sql
SQL
18 votes355 views3 answers
Get the list of all tables in sql server
SQL
2 votes334 views2 answers
Change varchar length mysql
SQL
9 votes367 views3 answers
Postgres make sql dump
SQL
2 votes366 views1 answer
Dbms transaction (psql)
SQL
0 vote323 views1 answer
Mysql terminal list table
SQL