Oracle ADD_MONTHS(date,num_months) function

ADD_MONTHS(date,num_months) -  Returns date + num_months

num_months is the number of months to add to date.

Sample:-

select ADD_MONTHS(sysdate,2) from dual  (assume today is 14-Mar-2008)

result:

14-MAY-08

select add_months('01-Apr-08', 3) from dual

result :
01-JUL-08