/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

5 votes287 views2 answers
Add days in oracle sql
SQL
1 vote212 views1 answer
Mysql see column types
SQL
0 vote262 views1 answer
Group by max date
SQL
5 votes248 views2 answers
Mysql drop table cascade
SQL
0 vote264 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote267 views1 answer
Delete a record from a table sqlite3
SQL
3 votes252 views1 answer
Oracle apex call duration
SQL
11 votes265 views1 answer
Oracle view source
SQL
5 votes244 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote256 views1 answer
Add timestamp column to existing table ms sql server
SQL