Select Query:
Output:
select order_date,add_months(order_date,1) from order_t5;
Output:
ORDER_DAT ADD_MONTH --------- --------- 12-JAN-96 12-FEB-96 25-JAN-96 25-FEB-96 18-FEB-96 18-MAR-96 03-APR-96 03-MAY-96