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 to locate SSN

BillWFeb 28 2011 — edited Mar 1 2011
Greetings,

I have been tasked with locating SSN strings in a clob and replacing them with dummy information. I am approaching this using REGEXP functions and am struggling a bit. If someone has written a function to do this and is willing to share it I would be very appreciative.

THank you.
Bill Wagman
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2011
Added on Feb 28 2011
7 comments
1,986 views