Oracle Cloud Infrastructure Documentation

Fixed String

Purpose

The Fixed String masking format replaces column data with a user-specified fixed string.

Inputs

  • Fixed String: The string that should be used to replace the column values. It should be valid for the column size.

Supported Data Types

  • Character
  • Large Object (LOB)

Characteristics

  • Combinable: Yes
  • Deterministic: Yes
  • Reversible: No
  • Uniqueness: No

Examples

  • Suppose you want to replace all the Social Security numbers in a column with ***-**-****. You can use the Fixed String masking format and provide this string as input.
  • Alternatively, you can combine multiple basic masking formats to mask a column value. For example, you can use the Fixed String masking format to ensure that the masked value starts with ***-**-. Then, you can use the Random Number masking format to randomly generate the remaining four digits.
  • Similarly, you can use the Fixed String masking format to ensure that the license plate numbers in a column start with "CA."