NVL(字段,0):将空值转化为0 regexp_replace(字段, ‘[1-9]‘ ,'') is not null; 将数字转化为0 转载于:https://www.cnblogs.com/jiningning/p/7084571.html