--------------- regexp_like(需要判断的字段名,‘^+?[1-9][0-9]*$‘) SELECT ID, PERIODSID, (case when regexp_like(LEADERNUM,‘^+?[1-9][0-9]*$‘) then TO_NUMBER(LEADERNUM) else 0 end) LEADERNUM from EXOA.T_week_meeting
原文：https://www.cnblogs.com/superming/p/14467495.html