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

2022-08-30 16:15:25

    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:]]‘,
                                        ‘‘);