NEXT_DAY
Syntax
NEXT_DAY(d,char)
It will return the date of the first weekday named through char which is later than the date d. An argument char must be a day of the week in the session's date language. The return value has the similar minutes, hours and seconds parts as the argument d.
Example
SELECT NEXT_DAY('06-DEC-00','TUESDAY') "NEXT DAY" FROM DUAL;
NEXT DAY
---------
12-DEC-00