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