ALL_TRANSFORMATIONS
ALL_TRANSFORMATIONS displays information about all transformations accessible to the current user.
These transformations can be specified with Advanced Queuing operations such as enqueue, dequeue, and subscribe to automatically integrate transformations in AQ messaging.
Related Views
-
DBA_TRANSFORMATIONSdisplays information about all transformations in the database. -
USER_TRANSFORMATIONSdisplays information about transformations owned by the current user. This view does not display theOWNERcolumn.
| 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(128) |
Source type name | |
TO_TYPE |
VARCHAR2(256) |
Target type name |
See Also: