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
Oracle判断值为非数字
最新推荐文章于 2024-07-30 17:39:10 发布
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