../E40402-16.epub /> ../E40402-16.mobi />

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
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

Note:

This view is available starting with Oracle Database 11g Release 2 (11.2.0.4).

See Also:

Oracle Database Advanced Security Administrator's Guide for more information about Oracle Data Redaction