oracle 正则表达式的一次使用经历

主要是在数据加工处理中使用：

数据处理过程如下：

CREATE OR REPLACE PROCEDURE P_DEAL_CMS_DOC IS

  CURSOR C_DEAL IS
    SELECT L.*,
           REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(L.TITLE,
                                                                       '鄂青发+.*?+[0-9]*+.*?+号'),
                                                        '鄂青[联办]发+.*?+[0-9]*+.*?+号'),
                                         '鄂青发+.*?+[〔【]+[0-9]{4}+[〕】]+.*?+[0-9]*+.*?+号'),
                          '鄂青[联办]发+.*?+[〔【]+[0-9]{4}+[〕】]+.*?+[0-9]*+.*?+号') AS TITLE_NEW,
           REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(L.CONTENT,
                                                                       '鄂青发+.*?+[0-9]*+.*?+号'),
                                                        '鄂青[联办]发+.*?+[0-9]*+.*?+号'),
                                         '鄂青发+.*?+[〔【]+[0-9]{4}+[〕】]+.*?+[0-9]*+.*?+号'),
                          '鄂青[联办]发+.*?+[〔【]+[0-9]{4}+[〕】]+.*?+[0-9]*+.*?+号') AS CONTENT_NEW,
           REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(L.SUMMARY,
                                                                       '鄂青发+.*?+[0-9]*+.*?+号'),
                                                        '鄂青[联办]发+.*?+[0-9]*+.*?+号'),
                                         '鄂青发+.*?+[〔【]+[0-9]{4}+[〕】]+.*?+[0-9]*+.*?+号'),
                          '鄂青[联办]发+.*?+[〔【]+[0-9]{4}+[〕】]+.*?+[0-9]*+.*?+号') AS SUMMARY_NEW
      FROM CMS_DOC L
     WHERE L."TYPE" = 2
       AND L.STATE = 4;

BEGIN
  FOR V_DEAL IN C_DEAL LOOP
    BEGIN
      UPDATE CMS_DOC
         SET TITLE   = V_DEAL.TITLE_NEW,
             CONTENT = V_DEAL.CONTENT_NEW,
             SUMMARY = V_DEAL.SUMMARY_NEW
       WHERE ID = V_DEAL.ID;
    END;
  END LOOP;

  COMMIT;

END P_DEAL_CMS_DOC;

解释：1、.*?    --匹配任意个数的空格字符；

          2、[〔【]  -- 匹配字符 〔 或者【；

          3、[联办]  -- 匹配汉字 '联'或者'办'；

          4、[0-9]*   --匹配任意个数的数字。