The Oracle and PL/SQL NEXT_DAY function returns the first weekday that is greater than a date.
NEXT_DAY(d,wd)
wd is a day of the week (SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY)
Example 1:
SELECT NEXT_DAY(TO_DATE('31/10/2007','DD/MM/YYYY'),'SATURDAY') FROM DUAL;
returns:
03/11/2007