Data masking functions provide various methods to transform
or mask sensitive data.
Lookup Functions
Use the lookup functions to select values from a lookup
table that are used to populate the target table. Use the Lookup and
Hash Lookup functions to select values based on the source value.
Alternatively, use the Random Lookup function to select values from
a lookup table without regard to the source value.
Shuffle Function
The Shuffle Function replaces a source value with another
value from the column that is then inserted in a destination column.
The source row and the row that contains the replacement value will
never be the same, but depending on your data, source and replacement
values can be identical.
TRANS SSN Function
Use the TRANS SSN function to generate a valid and unique
U.S. Social Security Number (SSN). By default, TRANS SSN algorithmically
generates a consistently altered destination SSN based on the source
SSN. TRANS SSN can also generate a random SSN when the source data
does not have an SSN value or when there is no need for transforming
the source SSN in a consistent manner.
TRANS CCN Function
Use the TRANS CCN function to generate a valid and unique
credit card number (CCN). By default, TRANS CCN algorithmically generates
a consistently altered CCN based on the source CCN. TRANS CCN can
also generate a random value when the source data does not have a
CCN value or when there is no need for transforming the source CCN
in a consistent manner.
TRANS EML Function
Use the TRANS EML function to generate an email address.
An email address consists of two parts, a user name followed by a
domain name, separated by ‘@'. For example, user@domain.com.
TRANS COL Function
The TRANS COL function can mask data that has no inherent
format or a format that is not widely known. TRANS COL maintains the
format and character type of the source data at the destination.
TRANS NID Function
Use the TRANS NID function to mask national ID numbers.
TRANS FILL Function
Use the TRANS FILL function to replace the data in a CHAR, VARCHAR or CLOB column with a character that you specify.
TRANS AGE Function
Use the TRANS AGE Function to age values in a source column.The source column can contain character, date, or timestamp.
data. A CHAR or VARCHAR column has a maximum length of 256 bytes.
Substring Function
The Substring Function returns a substring of the contents
of the named column.
Random Function
The Random Function returns a number selected at random
within the range indicated by the low and high values.
Sequential Function
The Sequential Function returns a number that is incremented
sequentially. The syntax is:
Identity or Serial Function
The Identity and Serial Functions direct the DBMS to supply
a sequential value (integer) for a destination column. The syntax
for these functions is:
Oracle Sequence Function
The Oracle Sequence Function assigns a value to the destination
column by using an Oracle Sequence.
Concatenated expressions
Concatenation allows you to combine column values or combine
a column value with another value, by using a concatenation operator
(CONCAT, ||, or +). A concatenated expression can include character
values or binary values, but not both:
Numeric expressions
Use a numeric expression to specify a value in the source
column whenever the data types for the corresponding source and destination
columns are compatible.
Literal and value functions
Use the literal and value functions to specify literals
such as a string or hexadecimal and values such as NULL or a special
register.
Age Function
Use the Age Function to age values in a source column.
The source column can contain character, numeric, date, or timestamp
data. A CHAR or VARCHAR column has a maximum length of 256 bytes.
Currency Function
Use the Currency Function to convert a currency value in
a source column from one currency to another. The source column must
be defined as numeric, but not floating point. Two conversion methods
are available:
Auto-Generated Email Name
The auto-generated email name function generates an email
address with a user name based on a literal concatenated with a sequential
number. The sequential numbers are suffixes that begin with 1 and
are incremented by 1. The function uses the domain name from an email
address in a specified source column.
Formatted Email Name
The formatted email name function generates an email address
with a user name based on values obtained from one or two attributes.
The policy uses the domain name from an email address in a specified
source column.
Random Number Function
The random number function generates numbers selected at
random within the range indicated by the low and high values.
Sequential Number Function
The sequential number function generates numbers that are
incremented sequentially.