/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

1 vote168 views4 answers
Between vs in sql
SQL
4 votes201 views1 answer
What are the data types
SQL
7 votes170 views3 answers
Sql get last inserted row
SQL
11 votes163 views2 answers
Mysql disable safe mode
SQL
0 vote163 views1 answer
Sql select rows between 1000 and 2000
SQL
8 votes127 views1 answer
Similarities between ddl and dml
SQL
4 votes175 views2 answers
Convert utc to est sql
SQL
0 vote164 views1 answer
Sql get month from date
SQL
1 vote174 views1 answer
Import mysql dump database command line linux
SQL
0 vote205 views1 answer
Sql quary stuf
SQL