Oracle Cloud Infrastructure Documentation

Random Number

Purpose

The Random Number masking format generates random integers within a specified range to replace column data.

Inputs

  • Start Number: The lower bound of the range within which the integers should be generated.
  • End Number: The upper bound of the range within which the integers should be generated.

The inputs can be any integers, including negative integers. Start Number must be less than or equal to End Number. They should be valid for the column size.

Supported Data Types

  • Character
  • Numeric

Characteristics

  • Combinable: Yes
  • Deterministic: No
  • Reversible: No
  • Uniqueness: Yes. The number of distinct values in the specified range must be greater than or equal to the number of values in the column.

Example

Suppose you have an EMPLOYEE_AGE column and you want to generate random ages from 21 through 65. You can use the Random Number masking format to generate random integers from 21 through 65, including those values.

The following table shows the original EMPLOYEE_AGE column and the MASKED_EMPLOYEE_AGE column.

EMPLOYEE_AGE MASKED_EMPLOYEE_AGE
21 59
35 22
51 43
28 38
64 61
75 21