/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 vote232 views1 answer
Get foreign table names mysql
SQL
0 vote202 views2 answers
Collation in sql
SQL
3 votes133 views1 answer
How to get list of synonyms in oracle
SQL
0 vote179 views1 answer
Like sql for second letter of the family name
SQL
5 votes195 views1 answer
Sql use database
SQL
3 votes184 views2 answers
Sql asc
SQL
0 vote195 views1 answer
Mysql workbench primary key
SQL
0 vote256 views1 answer
Call function sql oracle with output put line
SQL
0 vote180 views1 answer
Mysql create table columns with spaces
SQL
0 vote198 views1 answer
Sql last 3 rows
SQL