/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 vote143 views1 answer
Sql group by sum with condition
SQL
0 vote83 views1 answer
Check id exist or not in sql
SQL
0 vote128 views1 answer
Sql select merge multiple values
SQL
1 vote139 views1 answer
Psql connect to another database
SQL
0 vote116 views1 answer
User defined variables in sql
SQL
0 vote128 views1 answer
Get primary key of table
SQL
1 vote528 views1 answer
How to lock table in mysql
SQL
1 vote126 views1 answer
Partition by sql server
SQL
1 vote120 views4 answers
Get week day from date in sql
SQL
37 votes305 views3 answers
Sql check duplicate value in column
SQL