Oracle 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

12 votes228 views4 answers
How to take database dump in postgresql
SQL
0 vote250 views1 answer
Why do we need data structure in sql
SQL
9 votes231 views1 answer
Oracle get table schema
SQL
2 votes252 views3 answers
Sql truncate table
SQL
2 votes194 views1 answer
Latest record in sql
SQL
0 vote237 views1 answer
Typeorm raw sql
SQL
0 vote231 views1 answer
Postgres declare variable
SQL
0 vote228 views1 answer
Product of a column in mysql
SQL
1 vote244 views2 answers
Snowflake alter column data type
SQL
0 vote241 views2 answers
Oracle ora-00054 how to unlock
SQL