Create 90-day filter before a period

Question

I need you to bring back the results that completed 90 days within an informed period.

For example, I have the ability to do:

DT_INICIO_REAL <= (sysdate-90), I will have as a result 90 days from the current date

or DT_INICIO_REAL BETWEEN :DT_INICIO AND :DT_FIM I will have results of the period informed.

But I need to "merge" the two things, I want you to report a period, for example 01/10/2017 until 10/10/2017 and bring me the lines in which DT_INICIO_REAL complete 90 days within the reported period.

Answer 1

How about:

SELECT
    *
FROM
    TABELA
WHERE
    DT_INICIO_REAL BETWEEN to_date('01-OCT-2017') and to_date('10-OCT-2017') AND
    (trunc(sysdate) - DT_INICIO_REAL) >= 90;

See working on Sqlfiddle