ADD_MONTHS函数测试
SQL> select add_months(\'31-DEC-2008\',2.5) from dual;
ADD_MONTHS(\'
------------
28-FEB-09
SQL> select add_months(\'30-DEC-2008\',2.5) from dual;
ADD_MONTHS(\'
------------
28-FEB-09
SQL> select add_months(\'29-DEC-2008\',2.5) from dual;
ADD_MONTHS(\'
------------
28-FEB-09
SQL> select add_months(\'28-DEC-2008\',2.5) from dual;
ADD_MONTHS(\'
------------
28-FEB-09