Selecting All Transformations

Name of View

DBA_TRANSFORMATIONS

Purpose

This view displays all the transformations in the database. These transformations can be specified with Advanced Queue operations like enqueue, dequeue and subscribe to automatically integrate transformations in AQ messaging. This view is accessible only to users having DBA privileges.

Table 10-19 DBA_TRANSFORMATIONS

Column Name & Description	Null?	Type
TRANSFORMATION_ID--unique identifier for the transformation		NUMBER
OWNER--owning user of the transformation		VARCHAR2(30)
NAME-- transformation name		VARCHAR2(30)
FROM_TYPE--source type name		VARCHAR2(61)
TO_TYPE--target type name		VARCHAR2(61)
Namespace--one for transformations created by the Oracle transformation engine. Transformations from third party-transformation engines are in different namespaces.
From_type_schema--owning user of the source type
From_type_name--source type of the transformation
To_type_Schema--owning user of the destination type
To_type_name--destination type of the transformation. The transformation takes an object of the source type and returns an object of the destination type.
Transformation_type--type of the transformation. Values: SQL and XSL
Attribute_Name--attribute name of the destination type for which the transformation is being specified.
Transformation_Expression--can be a SQL expression, P/LSQL function, or an XSL document
Comment--user-specified comment.