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 scramble data like names, ssn with meaningful data?

320ac32f-edcf-4c4b-9181-a086a7a42975Jan 8 2015 — edited Jan 8 2015

Hi,

I want to scramble or desensitize data using SQL scripts.

Change NAMES with meaningful names. ex: "Smith" will be like "Taylor".

Change SSN with meaningful ssn. ex: "425635124" will be like "411638155".

Please help me on this.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 5 2015

Added on Jan 8 2015

4 comments

1,736 views