/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

5 votes165 views1 answer
Oracle create table comment
SQL
0 vote102 views1 answer
Update sql join multiple tables
SQL
2 votes141 views1 answer
Sql update from different table
SQL
0 vote160 views1 answer
Datagrip execute procedure
SQL
10 votes148 views1 answer
Oracle object dependencies
SQL
0 vote188 views1 answer
Offset in postgresql example
SQL
2 votes162 views3 answers
How to get second highest salary in each department in sql
SQL
3 votes153 views1 answer
Sql double index
SQL
0 vote158 views2 answers
Jsonb
SQL
4 votes137 views2 answers
Postgres update single column
SQL