/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 vote327 views1 answer
Mysql config slave
SQL
0 vote358 views1 answer
Sql date with year
SQL
0 vote337 views1 answer
Stored function in sql
SQL
0 vote325 views1 answer
SqlFunction does not exist
SQL
0 vote363 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote326 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
9 votes344 views5 answers
Laravel to sql
SQL
0 vote325 views1 answer
Sql create table with datetime automatically
SQL
0 vote340 views1 answer
Ms sql print more than 1 variable
SQL
0 vote326 views1 answer
RowDataPacket
SQL