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
- Supports Double-Byte Characters: Does not apply
- 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.