WITH
T AS (
SELECT '0123.01' S FROM DUAL UNION ALL
SELECT '-0123' S FROM DUAL UNION ALL
SELECT '-0123.01' S FROM DUAL UNION ALL
SELECT '012345' S FROM DUAL UNION ALL
SELECT '01234567 A' S FROM DUAL UNION ALL
SELECT '0123456789A' S FROM DUAL UNION ALL
SELECT 'ABC' S FROM DUAL
)
SELECT S "字段",
DECODE(TRIM(TRANSLATE(S,'0123456789',' ')),NULL,'YES','NO') "是否是纯数字",
DECODE(TRIM(TRANSLATE(S,'0123456789.-',' ')),NULL,'YES','NO') "是否是纯数字(带负号或者小数点)"
FROM T ;
ORACLE判断字符串是否为数字
最新推荐文章于 2024-07-30 17:39:10 发布