17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM base
WHERE city = 'ZS'
AND to_number(wapflow) > 1000
--空字符串删除
DELETE base WHERE wapflow = ''
--wapflow中有非数字字符的删除
DELETE base WHERE LENGTH(TRANSLATE(wapflow,'1234567890','')) > 0
regexp_like(wapflow,'^(\+|-)?[0-9]+(\.[0-9]+)?$')
[/quote]
考虑了,可以处理符号和小数,那个图片帖子请版主删除了吧[/quote]
以下是测试结果,你的正则表达式对存在小数的数字是无法匹配的
SQL> select 1 from dual where regexp_like('1.1','^[[:digit:]]+$');
未选定行
SQL> select 1 from dual where regexp_like('1.1','^(\+|-)?[0-9]+(\.[0-9]+)?$');
1
----------
1
SQL>
regexp_like(wapflow,'^(\+|-)?[0-9]+(\.[0-9]+)?$')
[/quote]
考虑了,可以处理符号和小数,那个图片帖子请版主删除了吧regexp_like(wapflow,'^(\+|-)?[0-9]+(\.[0-9]+)?$')