/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 vote188 views2 answers
Collation in sql
SQL
0 vote165 views1 answer
Table or view does not exist
SQL
0 vote159 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote164 views2 answers
Sql drop view if exists
SQL
0 vote178 views1 answer
Tsql pad left
SQL
0 vote192 views1 answer
Sql quary stuf
SQL
2 votes162 views1 answer
Postgresql update sequence next value
SQL
2 votes171 views2 answers
Mamp connect mysql terminal
SQL
-1 vote176 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote176 views1 answer
Oracle calculate statistics on partition
SQL