-
oracle正则表达式匹配数字
select * from scott.salary_2020 where regexp_like(income,'^-?([[:digit:]]*.[[:digit:]]*)$');
select * from scott.salary_2020 where regexp_like(income,'^-?(\d*.\d*)$');
select * from scott.salary_2020 where regexp_like(income,'^-?([0-9]*.[0-9]*)$');
select * from scott.salary_2020 where regexp_like(income,'^-?(\d*.\d*)$');
select * from scott.salary_2020 where regexp_like(income,'^-?([0-9]*.[0-9]*)$');
