SQL文如下:
select distinct b.dev_nm from (select dev_id, dev_nm from dmi_device where upkbn<>'D'
and nvl2(translate(dmi_device.dev_id, '+1234567890', '+'), 'is characters', 'is number') ='is number' ) b
where to_number('424')=to_number(b.dev_id)请各位大虾找下错误,并给出解决办法,小弟很着急,多谢!!!
解决了马上给分!
select distinct b.dev_nm from (select dev_id, dev_nm from dmi_device where upkbn<>'D'
and nvl2(translate(dmi_device.dev_id, '+1234567890', '+'), 'is characters', 'is number') ='is number' ) b
where to_number('424')=to_number(b.dev_id)请各位大虾找下错误,并给出解决办法,小弟很着急,多谢!!!
解决了马上给分!
这些记录的dev_id可以是'0422','00422'等。
from (select dev_id, dev_nm
from dmi_device
where upkbn <> 'D' and
translate(dmi_device.dev_id, '+1234567890', '+') is null) b
where b.dev_id = '424'
from dmi_device
where dev_id LIKE '%422%'
and upkbn<>'D'
where upkbn <> 'D'
and ltrim(dev_id,'0') = '424'