update busi.t_Ar_Contactinfo c set c.contactphone= regexp_replace(c.contactphone,'[^\x80-\xff]','')
from busi.t_ar_contactinfo c
where length(c.contactphone) <>
length(regexp_replace(c.contactphone, '[^\x80-\xff]', ''));
运行报ora=00933的错误
from busi.t_ar_contactinfo c
where length(c.contactphone) <>
length(regexp_replace(c.contactphone, '[^\x80-\xff]', ''));
运行报ora=00933的错误
正解,update后面不能加from