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

5 votes229 views1 answer
Mysql created at yesterdau
SQL
0 vote254 views1 answer
Sql server is not
SQL
1 vote206 views1 answer
Oracle show execution plan
SQL
5 votes195 views1 answer
Sysdate in oracle sql
SQL
1 vote210 views1 answer
T-sql disable system versioning
SQL
0 vote244 views1 answer
How to rename a database in tsql
SQL
0 vote217 views1 answer
Transaction and commit trong sql server
SQL
0 vote183 views1 answer
Procedure excute monthly oracle
SQL
1 vote209 views1 answer
How not to sort by average rating
SQL
0 vote188 views1 answer
Sql find gaps in date ranges
SQL