/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 vote179 views1 answer
Mysql add comment to column
SQL
8 votes171 views4 answers
Mysql update one table from another table multiple columns
SQL
2 votes217 views2 answers
Set value to null sql
SQL
0 vote189 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote176 views1 answer
Add column not null with default value postgres
SQL
0 vote171 views1 answer
Datagrip exec
SQL
1 vote193 views1 answer
Last 24 HOUR data in mysql
SQL
1 vote183 views1 answer
Oracle apex version view
SQL
0 vote203 views1 answer
Get the next column of a table in mysql
SQL
0 vote189 views1 answer
Column ' ' in field list is ambiguous
SQL