<div class=”codetitle”><a style=”CURSOR: pointer” data=”75521″ class=”copybut” id=”copybut75521″ onclick=”doCopy(‘code75521’)”> 代码如下:<div class=”codebody” id=”code75521″>
select nvl2(translate(name,’\1234567890 ‘,’\’),’is characters ‘,’is number ‘) from customer_info where nvl2(translate(name,’is number ‘)=’is number ‘