/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 vote184 views1 answer
How to access to mysql without root
SQL
1 vote192 views1 answer
Add current timestamp in mysql
SQL
-1 vote189 views1 answer
Mysql select all columns and specific fields as
SQL
3 votes256 views1 answer
Mysql cli connect with password
SQL
0 vote196 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote212 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote239 views1 answer
How to check foreign key constraint in sql
SQL
0 vote184 views1 answer
Mysql group rows with same value
SQL
0 vote156 views1 answer
Oracle sql developer script output limit
SQL
1 vote214 views1 answer
Mysql count all table rows
SQL