7.246 REDACTION_VALUES_FOR_TYPE_FULL

REDACTION_VALUES_FOR_TYPE_FULL shows all of the current values for full redaction.

For example, if a redaction policy is applied to a column of type BINARY_DOUBLE and the redaction type is full redaction, that column will be redacted with the value shown in the BINARY_DOUBLE_VALUE column of this view.

Column Datatype NULL Description

NUMBER_VALUE

NUMBER

NOT NULL

Redaction result for full redaction on NUMBER columns

BINARY_FLOAT_VALUE

BINARY_FLOAT

NOT NULL

Redaction result for full redaction on BINARY_FLOAT columns

BINARY_DOUBLE_VALUE

BINARY_DOUBLE

NOT NULL

Redaction result for full redaction on BINARY_DOUBLE columns

CHAR_VALUE

VARCHAR2(1)

Redaction result for full redaction on CHAR columns

VARCHAR_VALUE

VARCHAR2(1)

Redaction result for full redaction on VARCHAR2 columns

NCHAR_VALUE

NCHAR(1)

Redaction result for full redaction on NCHAR columns

NVARCHAR_VALUE

NVARCHAR2(1)

Redaction result for full redaction on NVARCHAR2 columns

DATE_VALUE

DATE

NOT NULL

Redaction result for full redaction on DATE columns

TIMESTAMP_VALUE

TIMESTAMP(6)

NOT NULL

Redaction result for full redaction on TIMESTAMP columns

TIMESTAMP_WITH_TIME_ZONE_VALUE

TIMESTAMP(6) WITH TIME ZONE

NOT NULL

Redaction result for full redaction on TIMESTAMP WITH TIME ZONE columns

BOOLEAN_VALUEFoot 1

 BOOLEAN

NOT NULL

Redaction result for full redaction on BOOLEAN columns

BLOB_VALUE

BLOB

Redaction result for full redaction on BLOB columns

CLOB_VALUE

CLOB

Redaction result for full redaction on CLOB columns

NCLOB_VALUE

NCLOB

Redaction result for full redaction on NCLOB columns

Footnote 1 This column is available starting with Oracle Database 23ai, Release Update 23.7, but it does not appear in this view by default. It is automatically added to this view when the value of the COMPATIBLE initialization parameter is 23.0.0 or higher, and a full redaction value for data type BOOLEAN is specified or a full redaction policy is defined on any column of BOOLEAN data type. See Oracle Database Data Redaction Guide for more information.

See Also:

Oracle Database Data Redaction Guide for more information about Oracle Data Redaction