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 vote256 views1 answer
Mysql command line top 10
SQL
0 vote233 views2 answers
Csv into data postgres
SQL
0 vote235 views1 answer
Pl sql constraint user function
SQL
0 vote238 views1 answer
Sqlite get date only
SQL
0 vote233 views1 answer
Set column width in sqlplus
SQL
0 vote234 views1 answer
View psql output in horizontal scrolling
SQL
3 votes246 views2 answers
Sql end of month
SQL
1 vote211 views1 answer
Stored procedure return value
SQL
2 votes226 views1 answer
Update trigger
SQL
17 votes242 views6 answers
Current date in sql
SQL