Oracle数据库分区表管理解决方案

create or replace procedure pro_add_partition_wareid
(tablename   in   varchar2, ---¨°a¨¬¨ª?¨®¡¤???¦Ì?¡À¨ª_
 revalue     out  number    ---1?¡é??¡¤Y¨¨??¨²?a??¡ê? 2?¡é¡¤???¨°??-¡ä??¨²¡ê?0?¡é?¨¢1??y3¡êp
) AS
  /*******************************************************
  author¡êoyanfei
  time  ¡êo2011/08/18
  1|?¨¹¡êo¨¬¨ª?¨®¡¤???¡À¨ª¦Ì????¡§¡¤???*
  ?¦Ì?¡Â¡êo?¨¦¨°?¨ª¡§1y?¡§¨º¡À¨¨???¨¤¡ä¨ª¨º3¨¦¡Á??¡¥¨¬¨ª?¨®¡¤???¡ê?¨¬¨ª?¨®o¨®¨°a?¨¬2¨¦?¡Â¨°y¦Ì?¡Á¡ä¨¬?0
        ¡Á?o?¨º????¡§?¡Â¨°y¡ê?¨°?¡ä?¦Ì???¡À¨ª¦Ì?¡¤????
  eg¡êo  exec pro_add_partition_wareid('d_order_bak');
  ********************************************************/
 tmp_parname        varchar2(40);
 tmp_strdate        varchar2(19);
 tmp_strbegin       varchar2(10);
 tmp_strend         varchar2(10);
 tmp_count          number;
 tmp_execsql        varchar2(2000);

begin
revalue := 0;
select max(mon) into tmp_strdate from t_user_detail where 1 = 1;
if tmp_strdate is null then
   revalue := 1;
   return;
end if;

--????¡¤?????3?1
select substr(to_char(add_months(to_date(tmp_strdate,'YYYY.MM'),1),'YYYY.MM'),1,4) into tmp_strbegin  from dual;
select substr(to_char(add_months(to_date(tmp_strdate,'YYYY.MM'),1),'YYYY.MM'),6,2) into tmp_strend    from dual;