Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF TZR';
WITH bounds (start_dt, end_dt) AS (
  SELECT DATE '2010-01-01',
         TRUNC(SYSDATE)
  FROM   DUAL
),
days (dt, ts) AS (
  SELECT start_dt + (LEVEL - 1),
         FROM_TZ(CAST(start_dt AS TIMESTAMP), 'America/Sao_Paulo')
           + INTERVAL '1' DAY * (LEVEL - 1)
  FROM   bounds
  CONNECT BY
         start_dt + (LEVEL - 1) <= end_dt
),
diff (dt, ts, diff) AS (
  SELECT dt,
         ts,
         LEAD(CAST(ts AS DATE)) OVER (ORDER BY ts) - CAST(ts AS DATE)
  FROM   days
)
SELECT dt
FROM   diff
WHERE  diff > 1


DT


2010-10-17 00:00:00

2011-10-16 00:00:00

2012-10-21 00:00:00

2013-10-20 00:00:00

2014-10-19 00:00:00

2015-10-18 00:00:00

2016-10-16 00:00:00

2017-10-15 00:00:00

2018-11-04 00:00:00