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 vote279 views1 answer
T sql dynamic top n query
SQL
0 vote274 views1 answer
Get the next column of a table in mysql
SQL
2 votes264 views1 answer
How to get non distinct values in sql
SQL
0 vote259 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
0 vote259 views1 answer
Oracle sql drop table
SQL
12 votes248 views2 answers
Delete all data in neo4j
SQL
17 votes257 views2 answers
Mysql date to string
SQL
0 vote263 views1 answer
Mysql make date from 2 column
SQL
0 vote247 views1 answer
Grant access on table in oracle
SQL
0 vote255 views1 answer
Get the previous column of a table in mysql
SQL