3.105 ALL_ATTRIBUTE_TRANSFORMATIONS

ALL_ATTRIBUTE_TRANSFORMATIONS describes the transformation functions for the transformations accessible to the current user.

Related Views

  • DBA_ATTRIBUTE_TRANSFORMATIONS describes the transformation functions for all transformations in the database.

  • USER_ATTRIBUTE_TRANSFORMATIONS describes 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(128)

NOT NULL

Owning user of the transformation

NAME

VARCHAR2(128)

NOT NULL

Transformation name

FROM_TYPE

VARCHAR2(257)

Source type name

TO_TYPE

VARCHAR2(385)

Target type name

ATTRIBUTE

NUMBER

NOT NULL

Target type attribute number

ATTRIBUTE_TRANSFORMATION

VARCHAR2(4000)

Transformation function for the attribute