Benefits and capabilities

We have seen different types of format entries that can be used when creating the masking format. The examples we used were Random Numbers, Encrypt (key-based reversible masking), Table Column, Array List, Random Digits, and Random Strings. Another format entry is Shuffle, which is used to randomly shuffle the values in a column across different rows. You can use this when the format of the column is unknown, making it impossible to generate realistic values. A user-defined function can also be used as the format entry to generate the masked value, for example, if an algorithm is required to derive a value such as an account number.

Alternatively, use Substitute as the format entry for deterministic masking. A table ...

Get Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.