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 vote206 views1 answer
Mysql change timestamp on update
SQL
1 vote193 views1 answer
Show all event schedular on mysql
SQL
0 vote235 views1 answer
Display all node label neo4j
SQL
2 votes358 views1 answer
Set auto increment from 1
SQL
0 vote198 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
4 votes241 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote177 views1 answer
Oracle list index on table
SQL
0 vote203 views1 answer
Primary key multiple
SQL
0 vote232 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote210 views1 answer
EnvironmentError: mysql_config not found
SQL