SQL>SQL> select next_day( date'2001-09-11', 'SUNDAY' ) 2 from dual;NEXT_DAY(---------16-SEP-011 row selected.SQL>SQL> --