how to check for non-numeric field (oracle)?

Ther is no buitin functions like isnumeric in oracle...
but you can use combination of some other functions for this.

situation :

Check for any non numeric charecters in the field code, table sc_mast

Table name : sc_mast
Field name : code


select * from sc_mast where LENGTH(TRIM(TRANSLATE(code, '0123456789', ' ')))>0

hope this will be helpful..
leave your comments