Finding rows that contain numeric or char data in Oracle

  

SQL> select DECODE( TRANSLATE('12345zzz_not_numberee',' 0123456789',' '), NULL, 'number','contains char')
 2 from dual
 3 /

SQL> select DECODE( TRANSLATE('12345',' 0123456789',' '), NULL, 'number','contains char')
 2 from dual
 3 /

"number"

 

https://stackoverflow.com/questions/12549029/sql-error-ora-01722-invalid-number