DBA_TRANSFORMATIONS

DBA_TRANSFORMATIONS provides information about all message transformations in the database. These transformations are specified with Advanced Queuing operations like enqueue, dequeue and subscribe to automatically integrate transformations in AQ messaging. DBA_TRANSFORMATIONS is available only to users with DBA privileges.

Related View

• USER_TRANSFORMATIONS lists information about transformations owned by particular users. It does not display the OWNER column.

  Column	Datatype	NULL	Description
  TRANSFORMATION_ID	NUMBER		Unique transformation identifier
  OWNER			User owning the transformation
  NAME	VARCHAR2(30)	NOT NULL	Name
  NAMESPACE	INTEGER		1 for transformations created by Oracle's transformation engine. Transformations from third party transformation engines are in different namespaces.
  FROM_TYPE_SCHEMA	VARCHAR2(30)		User owning the source type
  FROM_TYPE_NAME	VARCHAR2(30)		Transformation source type
  TO_TYPE_SCHEMA	VARCHAR2(30)		User owning the destination type
  TO_TYPE_NAME	VARCHAR2(30)		Transformation destination type. The transformation takes an object of the source type and returns an object of the destination type.
  TRANSFORMATION_TYPE	TYPE		Type of transformation: SQL, XSL
  ATTRIBUTE_NAME	VARCHAR2(30)		Attribute name of the destination type for which the transformation is being specified
  TRANSFORMATION_EXPRESSION	VARCHAR2(4000)		Transformation expression. Can be a SQL expression, PLSQL function or XSL document.
  COMMENT	VARCHAR2(4000)		User specified comment