oracle查询非数字字段的数据

select c.managername,
       nvl2(translate(c.managername, '\1234567890', '\'), '0', '1'), 
       c.*
  from tsm_enterprise_customer c
  left join tsm_enterprise_product p on c.pid = p.cus_id
 where c.managername is not null
   and  nvl2(translate(c.managername, '\1234567890', '\'), '0', '1') =0
   and p.product_id in (3037,3039)