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 vote175 views2 answers
Plsql function that return a table
SQL
1 vote208 views1 answer
Tsql create unique index composite
SQL
0 vote181 views1 answer
Except in sql alchemy
SQL
1 vote110 views1 answer
Insert into sql
SQL
0 vote177 views1 answer
Oracle enable chain
SQL
0 vote190 views1 answer
PSQL qith variables
SQL
1 vote185 views1 answer
Lpad function in sql oracle
SQL
5 votes155 views1 answer
Sql select ciunt
SQL
-1 vote160 views1 answer
Ssms connect with connection string
SQL
5 votes186 views1 answer
Oracle nls instance
SQL