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