select trim(translate(RTRIM(LTRIM(ITEM_NUMBER)), ‘#0123456789‘, ‘#‘)) from TestChar Where trim(translate(RTRIM(LTRIM(ITEM_NUMBER)), ‘#0123456789‘, ‘#‘)) is not null;
oracle数字字符串是否有非法数字
原文：http://www.cnblogs.com/lord-fly/p/4250793.html
