Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
DBA_ATTRIBUTE_TRANSFORMATIONS
displays information about the transformation functions for all transformations in the database.
USER_ATTRIBUTE_TRANSFORMATIONS
displays information about the transformation functions for the transformations owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
TRANSFORMATION_ID |
NUMBER |
NOT NULL |
Unique identifier for the transformation |
OWNER |
VARCHAR2(30) |
NOT NULL |
Owning user of the transformation |
NAME |
VARCHAR2(30) |
NOT NULL |
Transformation name |
FROM_TYPE |
VARCHAR2(61) |
Source type name | |
TO_TYPE |
VARCHAR2(91) |
Target type name | |
ATTRIBUTE |
NUMBER |
NOT NULL |
Target type attribute number |
ATTRIBUTE_TRANSFORMATION |
VARCHAR2(4000) |
Transformation function for the attribute |