Oracle SQL - Find special non numeric characters in field

oracle, select, sql, string

Solution

SELECT *
  FROM <table>
 WHERE REGEXP_LIKE(<column>, '[^[:digit:]]');

Hope it helps...

Problem

How can I identify the datas that have anything else than a number in them in a where clause ?

Original source