Find the records which contains non-numeric characters in a field

         To find the records which are all having non-numeric character in a given field using Regular Expression,



select 
empid 
from 
nmc_workflow 
where 
empid ~ '[^0-9]'