Which type of redaction in Oracle Data Redaction replaces all contents of a column with a single value?

Full redaction in Oracle Data Redaction is a method that replaces all contents of a column with a single predetermined value. This approach ensures that any sensitive information contained within the column is entirely obfuscated, which is particularly useful for protecting data that should not be disclosed to unauthorized users. The replacement value is typically a constant or a value that serves to maintain data type integrity while preventing the exposure of the underlying data.

This method is used in scenarios where the actual values held in a column are considered sensitive and must not be visible at all, thereby providing a high level of security and compliance with privacy regulations. It is most commonly applied to fields that contain personally identifiable information (PII) or other sensitive data where it is essential to ensure that no part of the original value can be inferred by access to the data.

The other types of redaction, such as partial redaction, regular expression redaction, and random redaction, offer different degrees of data obfuscation but do not replace all contents with a single value. Partial redaction may obscure only part of the data, regular expression redaction uses specified patterns to determine what to redact, and random redaction replaces data with random values, but none achieve the same level of complete data replacement as full