/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 vote374 views1 answer
Mysql best varchar length size
SQL
1 vote350 views1 answer
Select tables with name like mysql
SQL
0 vote384 views1 answer
SQL Cut part string
SQL
6 votes366 views1 answer
How to get the size of the database in postgresql
SQL
0 vote361 views1 answer
Mysql get last 2 month data
SQL
2 votes332 views5 answers
Alter table primary key postgresql
SQL
16 votes364 views3 answers
Update table from another table
SQL
0 vote363 views1 answer
Print boolean in plsql
SQL
5 votes326 views1 answer
Oracle asynchronous procedure
SQL
0 vote344 views2 answers
Auto increment column in mysql query results
SQL