How to know if an attribute contains non letters characters in oracle?

@wilmer.lemke 

You can check if an attribute contains non-letter characters in Oracle using a regular expression pattern.

Here is an example query that uses the REGEXP_LIKE function to search for non-letter characters in a column named 'attribute_name' in a table named 'table_name':

1
2
3

SELECT *
FROM table_name
WHERE REGEXP_LIKE(attribute_name, '[^a-zA-Z]');

In this query, the regular expression pattern '[^a-zA-Z]' is used to match any character that is not a letter (either lowercase or uppercase).

If the query returns any rows, it means that the 'attribute_name' column contains non-letter characters.