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!

Question - partial string masking

514950May 22 2009 — edited May 22 2009

Hi, all.

Using 10.2.0.4 on Win64.

I have some personal data in a database which I want to mask.

Some of the data is full VARCHAR(2) fields that I want to mask - in which case I'm leaning towards the TRANSLATE function.

I have other data in which only part of a VARCHAR(2) needs to be masked - for example, I have some email address fields, in which I want to leave the email domain intact.

I'm not sure how to approach this - I would like to apply the TRANSLATE function, but only up to the point where the '@' character appears.

Any suggestions as to how I could mask only part of a string?

Thanks!!

Doug W.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 19 2009

Added on May 22 2009

3 comments

938 views