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