Thanks to all who reply my simple question. I thought the add_months was just working on month level, so I tried to manage the year and month separately which cause the confusion. After Jackie, Marc, Mei pointed it out, I finally realized how to use this add_months function correctly.
Thanks again, Joan -- //www.freelists.org/webpage/oracle-l