Hello, i am lookin to find all entries in a table where the string consists of special characters. I've tried building the below pattern but not sure if it is the right approach.
SELECT 1 FROM dual WHERE regexp_like('CHRIS KAIZER, APS®, CoC® Chief Advisor', '.[^[:alnum:]]|[^[:space:]]|[^[:punct:]]');
So, any character other than alphanumerals, puntutation and space are to be considered as special characters. The particular trademark symbol in my example is not being categorized as alphanumeric where both the below queries are not returning results. Please can someone help in building the pattern.
SELECT 1 FROM dual WHERE regexp_like('®', '.[[:alnum:]]');
SELECT 1 FROM dual WHERE regexp_like('®', '.[^[:alnum:]]');