假如a 字段有以下几条记录:
a(字符型)
------------
(是空值非NULL)
-----------
12.3
------------
Wefd232EF=select to_number(nvl(a,0)) from tab where trim(translate(a,'0123456789',' ')) is null以上sql语句不能取到为空的记录。如何才能取出除了字段值是Wefd232EF=的记录
a(字符型)
------------
(是空值非NULL)
-----------
12.3
------------
Wefd232EF=select to_number(nvl(a,0)) from tab where trim(translate(a,'0123456789',' ')) is null以上sql语句不能取到为空的记录。如何才能取出除了字段值是Wefd232EF=的记录
--------------------123
WE23412K=已用时间: 00: 00: 00.50
SQL> SELECT * FROM TTT WHERE AAA IS NULL;未选定行已用时间: 00: 00: 00.40
SQL> SELECT TO_NUMBER(NVL(TRIM(AAA),0)) FROM TTT
2 WHERE TRIM(TRANSLATE(AAA,'0123456789.',' ')) IS NULL;TO_NUMBER(NVL(TRIM(AAA),0))
---------------------------
0
123已用时间: 00: 00: 00.60
SQL>
from tab
where trim(translate(a,'0123456789',' ')) is null; -- 10个空格