Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do you find an "unknown character" in a column

564814Feb 24 2011 — edited Feb 24 2011
I need to find out if any unknown characters exist in a column of datatype VARCHAR2 (in Oracle 9i). This column is in a large table of at least 10 Mi rows. REPLACE works to fix the unknown character when I know where the problem is. But, how do I do a clean up by identifying all such records in this column where an unknown character exists?

Any character which is not an alphabet or a number would be termed as an unknown.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2011
Added on Feb 24 2011
4 comments
1,475 views