Oracle Cloud Infrastructure Documentation

Supported Data Types

The following information applies to basic masking formats only.

Character Data Types

The following character types can use Delete Rows, Deterministic Encryption, Deterministic Substitution, Fixed Number, Fixed String, Group Shuffle, Null Value, Post Processing Function, Preserve Original Data, Random Decimal Number, Random Digits, Random List, Random Number, Random String, Random Substitution, Regular Expression, Shuffle, SQL Expression, Substring, Truncate Data, and User Defined Function masking formats:

  • CHAR
  • NCHAR
  • VARCHAR2
  • NVARCHAR2

Numeric Data Types

The following numeric types can use Delete Rows, Deterministic Encryption, Deterministic Substitution, Fixed Number, Group Shuffle, Null Value, Post Processing Function, Preserve Original Data, Random Decimal Number, Random Digits, Random List, Random Number, Random Substitution, Regular Expression, Shuffle, SQL Expression, Truncate Data, and User Defined Function masking formats:

  • NUMBER
  • FLOAT
  • RAW
  • BINARY_FLOAT
  • BINARY_DOUBLE

Date Data Types

The following date types can use Delete Rows, Deterministic Encryption, Deterministic Substitution, Group Shuffle, Null Value, Post Processing Function, Preserve Original Data, Random Date, Random List, Random Substitution, Shuffle, SQL Expression, Truncate Data, and User Defined Function masking formats:

  • DATE
  • TIMESTAMP

Large Object (LOB) Data Types

The following LOB data types can use Fixed Number, Fixed String, Null Value, Regular Expression, and SQL Expression masking formats:

  • BLOB
  • CLOB
  • NCLOB

Unsupported Objects

Oracle Data Safe does not support masking for the following:

  • External tables
  • Clustered tables
  • Queue tables
  • Long columns
  • XML-type columns
  • Virtual columns