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

1 vote136 views1 answer
Using SQL in rails migration
SQL
4 votes154 views2 answers
Mysql delete user if exists
SQL
0 vote167 views2 answers
How to list all values of a column that start with a letter in sql
SQL
4 votes142 views1 answer
Oracle show error line number
SQL
0 vote192 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
29 votes148 views6 answers
Delete all rows from table mysql
SQL
0 vote137 views1 answer
How to search query in python3 sqlite3
SQL
0 vote143 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote146 views1 answer
Pip install mysqlclient error
SQL
0 vote231 views1 answer
Install ms sql server management studio
SQL