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!

Identify junk characters

656368Jul 29 2009 — edited Jul 30 2009
I am trying to find all the rows that have junk characters in a specific column of the table and replace them with character x,following is the output I see for the column in question:

select contact_first_name,length(contact_first_name),dump(contact_first_name)
from customer_product_location where customer_product_id=188472276
,14,Typ=1 Len=14: 0,0,0,0,0,0,0,0,0,0,0,0,0,0
LAME,4,Typ=1 Len=4: 76,97,109,101
,14,Typ=1 Len=14: 0,0,0,0,0,0,0,0,0,0,0,0,0,0
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2009
Added on Jul 29 2009
#database
7 comments
18,370 views