3.121 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_TRANSFORMATIONS displays information about all transformations in the database.

• USER_TRANSFORMATIONS displays information about 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(128)		Source type name
TO_TYPE	VARCHAR2(256)		Target type name

See Also:

• "DBA_TRANSFORMATIONS"

• "USER_TRANSFORMATIONS"