SELECT *
FROM dates_test t0
WHERE (
(
t0.BEGIN_DATE >= TO_DATE('06-03-2014', 'DD-MM-YYYY')
AND t0.BEGIN_DATE <= TO_DATE('06-04-2014', 'DD-MM-YYYY')
)
OR (
t0.END_DATE >= TO_DATE('06-03-2014', 'DD-MM-YYYY')
AND t0.END_DATE <= TO_DATE('06-04-2014', 'DD-MM-YYYY')
)
OR (
t0.BEGIN_DATE <= TO_DATE('06-03-2014', 'DD-MM-YYYY')
AND t0.END_DATE >= TO_DATE('06-04-2014', 'DD-MM-YYYY')
)
);