/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 vote256 views1 answer
Show table structure mysql console
SQL
0 vote265 views1 answer
Sql server size of every table in a db
SQL
0 vote286 views1 answer
Sql decimal to 2 places
SQL
1 vote293 views1 answer
Insert many to many sql
SQL
4 votes255 views2 answers
Mysql select where starts with
SQL
0 vote313 views1 answer
How to use sqlcommand
SQL
1 vote266 views3 answers
How to truncate foreign key constraint table
SQL
0 vote303 views1 answer
Combine 2 columns search query mysql
SQL
0 vote251 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote208 views1 answer
Sqlalchemy existing database
SQL