eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.REDACTION_VALUES_FOR_TYPE_FULL

Object Details

Object Name:	REDACTION_VALUES_FOR_TYPE_FULL
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

SYS.REDACTION_VALUES_FOR_TYPE_FULL references the following:

SYS: RADM_FPTM$; RADM_FPTM_LOB$

SYS.REDACTION_VALUES_FOR_TYPE_FULL is referenced by following:

PUBLIC: REDACTION_VALUES_FOR_TYPE_FULL