/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

6 votes276 views1 answer
T-sql test if table exists
SQL
22 votes354 views4 answers
Mysql format date
SQL
0 vote281 views1 answer
Mysql drop trigger
SQL
1 vote276 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote273 views2 answers
Enter into postgresql database,create user and grant Access
SQL
1 vote262 views1 answer
Oracle convert run duration to number
SQL
4 votes316 views3 answers
Postgres drop all tables
SQL
0 vote291 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote267 views1 answer
Denormalise SQL command
SQL
0 vote258 views1 answer
How to populate a table in MySQL from and existing csv file
SQL