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

10 votes276 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote238 views1 answer
Sql min
SQL
0 vote267 views1 answer
Delete first row in sql
SQL
0 vote253 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
5 votes264 views1 answer
JBDC
SQL
0 vote249 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote255 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote273 views1 answer
Change database name psql 8
SQL
0 vote259 views1 answer
How to create a table in sql stack overflow
SQL
1 vote262 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL