/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 vote285 views1 answer
Sql last 7 days
SQL
0 vote300 views1 answer
Mysql url data type
SQL
0 vote287 views1 answer
Sql grant select only
SQL
0 vote315 views1 answer
Vbscript connect mssql
SQL
1 vote267 views2 answers
Procedure pl/sql
SQL
0 vote347 views1 answer
Osm2pgsql mac
SQL
0 vote268 views1 answer
Sqlite3 not commit
SQL
0 vote309 views1 answer
Insert set mysql
SQL
1 vote330 views1 answer
Floor function in sql oracle
SQL
2 votes305 views1 answer
How to get non distinct values in sql
SQL