/SQL/Oracle convert run_duration to number

Oracle convert 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 vote332 views1 answer
Alter table change default
SQL
0 vote309 views2 answers
Sql trigger difference between for and after
SQL
1 vote303 views1 answer
How to make a select in sql
SQL
0 vote348 views1 answer
How to inner join 4 tables in sql
SQL
2 votes368 views1 answer
Tcl in sql
SQL
0 vote309 views3 answers
Joins and views sql
SQL
0 vote308 views1 answer
Sql values not in another table
SQL
4 votes253 views1 answer
Oracle sleep
SQL
0 vote312 views2 answers
Soql last year
SQL
12 votes334 views6 answers
How to install sqlite3 in python
SQL