select 1 from dual where
12 BETWEEN 18 AND 19

Get next sunday

select NEXT_DAY( DATE '2022-11-30', 'SUNDAY' ) from dual;