The NEXT_DAY function returns the date of the day of the week following a particular date.
"day of the week" is expressed as the day written out (like Monday, Tuesday, etc.).
SQL>
SQL> SELECT NEXT_DAY(TO_DATE('15SEP2006','DDMONYYYY'),'Monday') FROM dual;
NEXT_DAY(
---------
18-SEP-06