Oracle Cloud Infrastructure Documentation

Fixed Number

Purpose

The Fixed Number masking format replaces column data with a user-specified fixed number.

Inputs

  • Fixed Number: The number that should be used to replace the column values. It can be any integer or decimal number, including negative numbers. The specified number should be valid for the column size.

Supported Data Types

  • Character
  • Numeric
  • 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 999999999. You can use the Fixed Number masking format and provide this number as input.
  • Alternatively, you can combine multiple basic masking formats to mask a column value. For example, you can use the Fixed Number masking format to ensure that the masked value starts with 990. Then, you can use the Random Number masking format to randomly generate the remaining seven digits.