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

Object Details

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

Rules-based transform functions used by Streams

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_OWNER	VARCHAR2	(128)	Yes	The owner of the rule associated with the transform function
RULE_NAME	VARCHAR2	(128)	Yes	The name of the rule associated with the transform function
VALUE_TYPE	VARCHAR2	(4000)		The type of the transform function name. This type must be VARCHAR2 for a rule-based transformation to work properly
TRANSFORM_FUNCTION_NAME	VARCHAR2	(4000)		The name of the transform function, or NULL if the VALUE_TYPE is not VARCHAR2
CUSTOM_TYPE	VARCHAR2	(11)		The type of the transform function

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RULE_OWNER
,      RULE_NAME
,      VALUE_TYPE
,      TRANSFORM_FUNCTION_NAME
,      CUSTOM_TYPE
FROM SYS.DBA_STREAMS_TRANSFORM_FUNCTION;

Dependencies

[top of page]

SYS.DBA_STREAMS_TRANSFORM_FUNCTION references the following:

SYS: ANYDATA; RE$NV_ARRAY; _DBA_STREAMS_TRANSFM_FUNCTION

SYS.DBA_STREAMS_TRANSFORM_FUNCTION is referenced by following:

PUBLIC: DBA_STREAMS_TRANSFORM_FUNCTION
SYS: ALL_STREAMS_TRANSFORM_FUNCTION