NEXT_DAY function

NEXT_DAY(x, day) returns the date of the next day following x. day is specified as a literal string (SATURDAY, for example).

The following example displays the date of the next Saturday after January 1, 2008:

SQL> SELECT NEXT_DAY('01-JAN-2008', 'SATURDAY') FROM dual;

NEXT_DAY(
---------
05-JAN-08

SQL>