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!

Scramble/Mask part of a string

user1980Nov 26 2010 — edited Nov 26 2010
Hi, I am on 10g. I need to scramble the last 5 characters of a string, say with character "X". This is to mask confidential data. I do not want to encrypt it but scramble the data from it original content so that confidentiality of the data is maintained.

Any help would be appreciated.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 24 2010
Added on Nov 26 2010
3 comments
1,636 views