/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 vote232 views2 answers
Jupyter notebook connect to database
SQL
0 vote277 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote290 views4 answers
Rownum in sql
SQL
1 vote289 views1 answer
How to between in sql
SQL
0 vote292 views1 answer
Greater than or equal to symbol in postgres
SQL
25 votes290 views6 answers
Modify column name in mysql
SQL
0 vote302 views1 answer
Rails sql query converstion
SQL
0 vote316 views1 answer
Select year from dual oracle
SQL
1 vote238 views1 answer
Into sql
SQL
4 votes300 views3 answers
Employee name starting with in sql
SQL