select next_day( date'2002-01-01', 'FRI' )
SQL> SQL> select next_day( date'2002-01-01', 'FRI' ) 2 from dual; NEXT_DAY( --------- 04-JAN-02 1 row selected. SQL> SQL> --