Thursday, April 14, 2016

Oracle Statement to extract fields that has numeric value

I have this data where users should input a description of profession. But one day, i found out that there are pure numeric entries. I need to query all record where PROFESSION column has numeric value.

Oracle Statement to extract fields that has numeric value

 SELECT EMPID, NAME, PROFESSION  
 FROM EMPLOYEE  
 WHERE REGEXP_LIKE(PROFESSION, '^[[:digit:]]+$')  

No comments:

Post a Comment