Oracle推断值为非数字

select * from product_info t where t.contract_detailid is not null
and length(translate(t.contract_detailid,'-.0123456789'||t.contract_detailid,'-.0123456789'))<>length(t.contract_detailid) for update

posted @   gccbuaa  阅读(170)  评论(0编辑  收藏  举报
点击右上角即可分享
微信分享提示