/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

4 votes229 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote244 views1 answer
TSQL convert csv to table
SQL
4 votes273 views1 answer
Rename stored procedure in sql server
SQL
3 votes243 views2 answers
Mysql create database
SQL
0 vote233 views1 answer
Retornar apenas o ano mysql date
SQL
0 vote242 views1 answer
Postgres create extension if not exists
SQL
1 vote221 views1 answer
Mysql server does not start mac
SQL
35 votes239 views6 answers
Postgres
SQL
2 votes187 views1 answer
Sql group by different columns
SQL
4 votes229 views1 answer
Oracle table statistics last analyzed
SQL