oracle 正则表达式 非字母 非数字

    Update ods_qad_cust_ar s
       Set s.customer = regexp_replace(customer,
                                        ‘[^[:alpha:]|^[:digit:]]‘,
                                        ‘‘);
                                       
         Update ods_qad_cust_aP s
       Set s.SUPPLIER = regexp_replace(SUPPLIER,
                                        ‘[^[:alpha:]|^[:digit:]]‘,
                                        ‘‘);
                                       

原文：https://www.cnblogs.com/shuihaya/p/13232800.html