/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

13 votes139 views3 answers
Uninstall mysql centos 7
SQL
0 vote140 views1 answer
How to generate ids in sql
SQL
0 vote129 views1 answer
Show database not empty tables postgres
SQL
6 votes142 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
4 votes129 views4 answers
What is primary key
SQL
0 vote139 views1 answer
How to set up an anonymous function to variable in swift
SQL
11 votes167 views2 answers
Import sql file laravel cmd
SQL
1 vote142 views1 answer
Mysql how to truncate table with foreign keys
SQL
0 vote139 views1 answer
Hibernate with springboot mysql
SQL
0 vote141 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL