How to find invalid utf-8 character in oracle column?

@orpha 

To find invalid UTF-8 characters in an Oracle column, you can use the following query:

1
2
3

SELECT *
FROM your_table
WHERE REGEXP_LIKE(your_column, '[^[:ascii:]]');

This query uses the REGEXP_LIKE function to find any characters in the column that are not in the ASCII character set, which may indicate invalid UTF-8 characters. You can replace 'your_table' with the name of your actual table and 'your_column' with the name of the column you want to check.