ADD_MONTHS

The Oracle & PLSQL ADD_MONTHS function returns a date plus n months.

ADD_MONTHS(d,n)

Example 1:

SELECT ADD_MONTHS(TO_DATE('31/10/2007','DD/MM/YYYY'),4) FROM DUAL;

returns:

29/02/2008