復制代碼 代碼如下:

select nvl2(translate(name,'/1234567890 ', '/'),'is characters ','is number ') from customer_info where nvl2(translate(name,'/1234567890 ', '/'),'is characters ','is number ')='is number '