/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

0 vote222 views1 answer
Sql query to get column names and data types in sql server
SQL
11 votes229 views1 answer
Oracle insert from select
SQL
0 vote221 views1 answer
Drop CHECK constraint sql
SQL
2 votes240 views3 answers
Mysql kill
SQL
0 vote227 views1 answer
Get date ISO in psql
SQL
1 vote212 views2 answers
String to date postgres
SQL
5 votes207 views1 answer
Oracle asynchronous query
SQL
9 votes209 views4 answers
How to remove duplicate in sql
SQL
0 vote221 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote212 views2 answers
Mysql multiply
SQL