Oracle Cloud Infrastructure Documentation

Null Value

Purpose

The Null Value masking format replaces column data with NULL. The column being masked must be allowed to contain null values.

Inputs

  • No inputs are required.

Supported Data Types

  • Character
  • Numeric
  • Date
  • Large Object (LOB)

Characteristics

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

Example

Suppose you have a column named SALARY that contains salary information and you want to replace those numbers with NULL. You can apply the Null Value masking format to the SALARY column.