ALL_STREAMS_TRANSFORM

3.93 ALL_STREAMS_TRANSFORM_FUNCTION

ALL_STREAMS_TRANSFORM_FUNCTION displays information about the rule-based transformation functions accessible to the current user.

Related View

DBA_STREAMS_TRANSFORM_FUNCTION displays information about all rule-based transformation functions in the database.

Column	Datatype	NULL	Description
`RULE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the rule associated with the transformation function
`RULE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the rule associated with the transformation function
`VALUE_TYPE`	`VARCHAR2(4000)`		Type of the transformation function name. This type must be `VARCHAR2` for a rule-based transformation to work properly.
`TRANSFORM_FUNCTION_NAME`	`VARCHAR2(4000)`		Name of the transformation function (NULL if `VALUE_TYPE` is not `VARCHAR2`)
`CUSTOM_TYPE`	`VARCHAR2(11)`		Type of the transformation function: `ONE TO ONE` - One-to-one transformations `ONE TO MANY` - One-to-many transformations