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

0 vote163 views2 answers
SQL BULK INSERT
SQL
1 vote132 views2 answers
Copy table in sql
SQL
16 votes134 views4 answers
Find duplicates mysql
SQL
0 vote124 views1 answer
Get date ISO in psql
SQL
1 vote336 views1 answer
How to make a select in sql
SQL
0 vote113 views1 answer
Drop tables from local database postgres pgadmin
SQL
1 vote114 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
11 votes122 views1 answer
How to get ddl for materialized view
SQL
2 votes113 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
3 votes107 views2 answers
Postgres download
SQL