select trim(translate(RTRIM(LTRIM(ITEM_NUMBER)), ‘#0123456789‘, ‘#‘))
  from TestChar
 Where trim(translate(RTRIM(LTRIM(ITEM_NUMBER)), ‘#0123456789‘, ‘#‘)) is not null;

oracle数字字符串是否有非法数字