In Tech Office: Oracle: Check ISNUMBER

2011年1月21日星期五

select decode(translate('A123456','1234567890','Y'),'Y','Y','N') from dual

select decode(translate('123456','1234567890','Y'),'Y','Y','N') from dual