/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 vote238 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote241 views1 answer
Consulta alias con inner join
SQL
0 vote242 views1 answer
Oracle tablespace autoextend
SQL
0 vote242 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote220 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote232 views1 answer
Alter database name script
SQL
0 vote228 views1 answer
C# check if mysql query modified rows
SQL
16 votes254 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
-1 vote220 views1 answer
Module operator in oracle sql
SQL
5 votes233 views3 answers
Mysql extract month from date
SQL