select nvl2(translate(name,'1234567890 ', ''),'is characters ','is number ') from customer_info where nvl2(translate(name,'1234567890 ', ''),'is characters ','is number ')='is number '
2014-06-07 07:17:07
相关操作代码如下：