Oracle Cloud Infrastructure Documentation

Shuffle

Purpose

The Shuffle masking format randomly shuffles values within a column.

Shuffle preserves data distribution. Suppose a column has 100 values, and all values are either 21 or 10, and the value 21 appears 60 times and the value 10 appears 40 times, after shuffling this column, this count remains same.

Inputs

  • No input values are required.

Supported Data Types

  • Character
  • Numeric
  • Date

Characteristics

  • Combinable: No
  • Deterministic: No
  • Reversible: No
  • Uniqueness: Yes, provided the column values are all unique

Example

In the following table, the values in the SALARY column are shuffled in the SHUFFLED_SALARY column.

EMPLOYEE JOB_CATEGORY SALARY SHUFFLED_SALARY
Alice M 90 70
Bill M 88 57
Carol W 72 88
Denise W 57 45
Eddie W 70 90
Frank W 45 72