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

7 votes224 views2 answers
Postgres concat
SQL
0 vote202 views1 answer
Insert or update cassandra
SQL
8 votes215 views1 answer
Oracle search stored procedures for text
SQL
0 vote214 views2 answers
How to find max and min salary in sql
SQL
4 votes191 views3 answers
Mysql varchar length
SQL
0 vote851 views2 answers
Remove mysql workbench ubuntu
SQL
2 votes210 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote207 views1 answer
Limit in access query
SQL
5 votes199 views2 answers
Sql number columns
SQL
0 vote228 views1 answer
Varchar format not case sensitive sql
SQL