Answers for "oracle convert run_duration to number"

SQL

2

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;

Posted by: Guest on June-07-2021

Source

Code answers related to "oracle convert run_duration to number"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#