/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

1 vote145 views1 answer
Mysql random limit 1
SQL
0 vote143 views1 answer
Update set with inner join oracle
SQL
1 vote145 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote149 views1 answer
Contact mysql column field
SQL
0 vote165 views1 answer
Add column in sql server ubuntu
SQL
0 vote139 views1 answer
How to stop all connections to a psql 12 database?
SQL
8 votes145 views4 answers
Mysql update one table from another table multiple columns
SQL
2 votes149 views1 answer
Alter table add column and foreign key mysql
SQL
4 votes145 views3 answers
Mysql update with join
SQL
2 votes150 views1 answer
Pandas to sql index
SQL