Oracle判断指定列是否全部为数字命令



Oracle判断指定列是否全部为数字命令: select nvl2(translate(name,’\1234567890 ‘, ‘\’),’is   characters ‘,’is   number ‘) from customer_info where nvl2(translate(name,’\1234567890 ‘, ‘\’),’is   characters ‘,’is   number ‘)=’is   number ‘