NEXT_DAY: the date of the day of the week following a particular date
SQL> -- NEXT_DAY: the date of the day of the week following a particular date
SQL>
SQL>
SQL> SELECT NEXT_DAY(TO_DATE('15SEP2006','DDMONYYYY'),'Monday')
2 FROM dual;
NEXT_DAY(
---------
18-SEP-06
SQL>