Adding One Month a certain date
SQL> SQL> Select ADD_MONTHS(TO_DATE('31-MAR-99'),1) from DUAL; ADD_MONTHS(TO_DATE(' -------------------- 30-APR-0099 00:00:00 1 row selected. SQL> SQL> --