ALL_STREAMS_TRANSFORM_FUNCTION displays information about the rule-based transformation functions accessible to the current user.
DBA_STREAMS_TRANSFORM_FUNCTION displays information about all rule-based transformation functions in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
RULE_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the rule associated with the transformation function |
RULE_NAME |
VARCHAR2(30) |
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) |
For one-to-one transformations, the value is ONE TO ONE.
For one-to-many transformations, the value is Otherwise, it is null. |
See Also:
Oracle Streams Concepts and Administration for more information about custom rule-based transformation