NVL2(TRANSLATE(trim(replace(translate(字段名,'0123456789.'||字段名,'0123456789.'),'.','')),'/1234567890','/'),'CHAR','NUMBER')='NUMBER' and nvl(LENGTH(REGEXP_REPLACE(REPLACE(translate(字段名,'0123456789.'||字段名,'0123456789.'), '.', '@'), '[^@]+', '')),0)<=1 then cast(nvl(translate(字段名,'0123456789.'||字段名,'0123456789.'),'10.1') as number(4,1))
oracle取字符串中数字(包含小数),判断是否为数字
于 2023-06-28 18:12:34 首次发布