oracle finding day of week

[PAVB]

Try this for seven Sundays in advance counting from next Sunday.

select NEXT_DAY((sysdate + 49), 'SUN') from dual;