Extracting the total number of seconds from an interval data-type

An easy way:

select extract(day from (ts1-ts2)*86400) from dual;

The idea is to convert the interval value into days by times 86400 (= 24*60*60).
Then extract the ‘day’ value which is actually second value we wanted.