[sql] 날짜모음

select                    to_char(add_months(to_date(&ARG_YYYYMMDD,'YYYYMMDD'),+1),'YYYY                MMDD') AS YYYYMMDD_NEXT_MONTH 

  from 

dual;

==>

&ARG_YYYYMMDD : 20140901

RESULT:20141001