大概是我表达的不清楚,我的意思是读取表中数据全部是数字的结果,不是要改变结果 这个过滤用的不准确sorryselect column from table where ......使select的查询结果是column字段中全部是数字的数据
SQL> create table A 2 ( 3 A1 VARCHAR2(10) 4 ) 5 /Table createdSQL> SQL> insert into a values('qqqqqq');1 row insertedSQL> insert into a values('1234767');1 row insertedSQL> insert into a values('123wwww');1 row insertedSQL> insert into a values('123');1 row insertedSQL> insert into a values('eeeee123');1 row insertedSQL> insert into a values('33ee13');1 row insertedSQL> insert into a values('ee33ee13');1 row insertedSQL> select a1 from a where rtrim(a1,'0123456789') is null;A1 ---------- 1234767 123你不是要类似这样的需求吗?应该没有理解错吧?
说明全部为数字
这种写法也是正确的:where ltrim(column,' 0123456789')
这个过滤用的不准确sorryselect column from table where ......使select的查询结果是column字段中全部是数字的数据
2 (
3 A1 VARCHAR2(10)
4 )
5 /Table createdSQL>
SQL> insert into a values('qqqqqq');1 row insertedSQL> insert into a values('1234767');1 row insertedSQL> insert into a values('123wwww');1 row insertedSQL> insert into a values('123');1 row insertedSQL> insert into a values('eeeee123');1 row insertedSQL> insert into a values('33ee13');1 row insertedSQL> insert into a values('ee33ee13');1 row insertedSQL> select a1 from a where rtrim(a1,'0123456789') is null;A1
----------
1234767
123你不是要类似这样的需求吗?应该没有理解错吧?