Delete Rows

Purpose

The Delete Rows masking format deletes the rows that meet a user-specified condition. It is useful in conditional masking when you want to delete a subset of values in a column and mask the remaining values using some other masking formats. You should be careful while using this masking format. If no condition is specified, all rows in a table are deleted. If a column is being masked using Delete Rows, there must not be a foreign key constraint or dependent column referring to the table.

Inputs

No inputs are required.

Supported Data Types

Character
Numeric
Date

Characteristics

Supports Double-Byte Characters: Does not apply
Combinable: No
Deterministic: Does not apply
Reversible: No
Uniqueness: Does not apply

Example

Assume that a table has EMPLOYEE_ID and SALARY columns, and you want to delete the salary data for a subset of employee IDs. You can specify a condition on the SALARY column using EMPLOYEE_ID to delete rows matching the condition. You can use some other masking formats to mask the remaining salary values.

The logic to mask SALARY might look like the following:

EMPLOYEE_ID < 100   
      DELETE ROWS
EMPLOYEE_ID < 200
      RANDOM NUMBER [Start Value:30000 End Value:500000]
DEFAULT
      PRESERVE ORIGINAL DATA