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