Oracle Cloud Infrastructure Documentation

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

  • 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