I'm looking at configuring Oracle Data Redaction on a server we're using to block out some SSNs we don't really need to see. Unfortunately, our SSNs are stored as numeric, which means that here in New England, we have a lot that come out short. I set it up with the format DBMS_REDACT.REDACT_NUM_US_SSN_F5, which means they should look like 999996789. However, some of them come out as 9999989.
Does anybody know how to get this to come out right? I tried configuring them as RegExps, but that apparently only works for strings. I could leave it as it is, but that bothers my sense of aesthetics. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGd8Mrcn6Xw7B332PwPM_Lm2sUkk5kowHiFOhNqN3b=mjc2...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
