This will add the specified months to the given date.
Syntax: add_months (date,
no_of_months)
Ex:
SQL> select add_months(to_date('11-jan-1990','dd-mon-yyyy'), 5) from
dual;
ADD_MONTHS
----------------
11-JUN-90
SQL> select
add_months(to_date('11-jan-1990','dd-mon-yyyy'), -5) from dual;
ADD_MONTH
---------------
11-AUG-89
Ø If no_of_months is zero then it will
display the same date.
Ø If no_of_months is null then it will
display nothing.
