How to calculate scheduler job repeat interval in (seconds) via sql statement

Hi

Oracle 10g, 11g, 12c

I am looking a way to calculate scheduler job repeat interval in seconds via sql select statement.

select owner, job_name, repeat_intervalfrom dba_scheduler_jobs;

Bear in mind that dba_scheduler_job.repeat_interval can be specified many ways:

FREQ=HOURLYSYSDATE+(1/24/60)SYSDATE+(1/24/60/60*10)FREQ=WEEKLY;BYDAY=MON;BYHOUR=7;BYMINUTE=30;BYSECOND=0FREQ=MINUTELY;INTERVAL=10;BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN;BYHOUR=7FREQ=WEEKLY;BYDAY=MON;BYHOUR=8;BYMINUTE=0;BYSECOND=0....

I have tried converting, but either way, I get different error messages:

[Error] Execution (15: 58): ORA-01722: invalid number[Error] Execution (16: 27): ORA-01821: date format not recognized[Error] Execution (13: 19): ORA-01858: a non-numeric character was found where a numeric was expected