Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Waukesha WI

    Question Unanswered: Efficiently scrambling fields

    I need to take two fields from one table, scramble them while maintaining their integrity and place them into another. These are personal identifiers and the person can be in the file more than once. The resultant table should have the same "matches".

    I'm thinking of using decode() in some way, but being a novice at Oracle, I'm thinking there might be a common way to do this.

    Anyone have any ideas?

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    If you are looking for something simple look at TRANSLATE function.

    Otherwise look into DBMS_OBFUSCATION_TOOLKIT package.
    Last edited by LKBrwn_DBA; 03-09-06 at 18:23.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts