Results 1 to 5 of 5

Thread: Dummy Data

  1. #1
    Join Date
    Aug 2005
    Posts
    40

    Unanswered: Dummy Data

    Hello,

    I have a question. Lets say we have a table with column that has credit card numbers and/or social security numbers and we want to replace those numbers with "dummy data" for security purposes. Is there a package or procedure that will do this or do I need a third party utility?

  2. #2
    Join Date
    Oct 2002
    Location
    Cape Town, South Africa
    Posts
    253

  3. #3
    Join Date
    Aug 2005
    Posts
    40
    Dayneo,

    Thank you for your response. If I am not mistaken, doesn't dbms_random only allow up to 8 digit number?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >doesn't dbms_random only allow up to 8 digit number?
    & that is a problem, why?
    Do you get only a single call per lifetime?
    What would happen if you save the 1st results & called it again?
    Now you have 16 random digits.
    If that is not enough, call it again.
    Repeat as many times as necessary.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Oct 2002
    Location
    Cape Town, South Africa
    Posts
    253
    I think anacedent has got it there. Call dbms_random as many times as needed to build up a number of the required length.

    Just a quick thought, you could maybe even use sys_guid function and then convert the letters that are generated to numbers by converting them to their ascii number and subtracting 64 for each character. Guids have 32 chars in them (alpha numeric) so you will land up with a number larger than 32 chars. Simply substr to get the desired size.

    Note however, that on AIX server this function returns an incremental guid instead of a random one.

Posting Permissions

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