select amout
from test1
where trim(translate(amout, '0123456789.X', ' ')) is not null;
Oracle查看某一列数据是否不包含那些字符
最新推荐文章于 2023-04-27 00:37:58 发布
select amout
from test1
where trim(translate(amout, '0123456789.X', ' ')) is not null;