[Home] [Help] [Dependency Information]
Object Name: | REDACTION_VALUES_FOR_TYPE_FULL |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NUMBER_VALUE | NUMBER | Yes | Redaction result for full redaction on NUMBER columns | |
BINARY_FLOAT_VALUE | BINARY_FLOAT | (4) | Yes | Redaction result for full redaction on BINARY_FLOAT columns |
BINARY_DOUBLE_VALUE | BINARY_DOUBLE | (8) | Yes | Redaction result for full redaction on BINARY_DOUBLE columns |
CHAR_VALUE | CHAR | (1) | Redaction result for full redaction on CHAR columns | |
VARCHAR_VALUE | VARCHAR2 | (1) | Redaction result for full redaction on VARCHAR2 columns | |
NCHAR_VALUE | NCHAR | (2) | Redaction result for full redaction on NCHAR columns | |
NVARCHAR_VALUE | NVARCHAR2 | (2) | Redaction result for full redaction on NVARCHAR2 columns | |
DATE_VALUE | DATE | Yes | Redaction result for full redaction on DATE columns | |
TIMESTAMP_VALUE | TIMESTAMP(6) | (11) | Yes | Redaction result for full redaction on TIMESTAMP columns |
TIMESTAMP_WITH_TIME_ZONE_VALUE | TIMESTAMP(6) WITH TIME ZONE | (13) | Yes | Redaction result for full redaction on TIMESTAMP WITH TIME ZONE columns |
BLOB_VALUE | BLOB | (4000) | Redaction result for full redaction on BLOB columns | |
CLOB_VALUE | CLOB | (4000) | Redaction result for full redaction on CLOB columns | |
NCLOB_VALUE | NCLOB | (4000) | Redaction result for full redaction on NCLOB columns |
Cut, paste (and edit) the following text to query this object:
SELECT NUMBER_VALUE
, BINARY_FLOAT_VALUE
, BINARY_DOUBLE_VALUE
, CHAR_VALUE
, VARCHAR_VALUE
, NCHAR_VALUE
, NVARCHAR_VALUE
, DATE_VALUE
, TIMESTAMP_VALUE
, TIMESTAMP_WITH_TIME_ZONE_VALUE
, BLOB_VALUE
, CLOB_VALUE
, NCLOB_VALUE
FROM SYS.REDACTION_VALUES_FOR_TYPE_FULL;
|
|
|