NEXT_DAY and ADD_MONTHS in oracle 11g
SELECT TO_CHAR(NEXT_DAY(ADD_MONTHS (hire_date, 6), 'FRIDAY'), 'fmDay, Month ddth, YYYY') "Next 6 Month Review" FROM employees ORDER BY hire_date;
Here, we have initially called ADD_MONTHS function and then, called NEXT_DAY function.