Oracle9i Supplied PL/SQL Packages and Types Reference Release 2 (9.2) Part Number A96612-01 |
|
DBMS_TRANSFORM, 2 of 2
Subprograms | Description |
---|---|
Creates a transformation that maps an object of the source type to an object of the destination type |
|
Modifies an existing transformation |
|
Drops the given transformation |
This procedure creates a transformation that maps an object of the source type to an object of the target type. The transformation expression can be a SQL expression or a PL/SQL function. It must return an object of the target type.
DBMS_TRANSFORM.CREATE_TRANSFORMATION ( schema VARCHAR2(30), name VARCHAR2(30), from_schema VARCHAR2(30), from_type VARCHAR2(30), to_schema VARCHAR2(30), to_type VARCHAR2(30), transformation VARCHAR2(4000));
This procedure modifies (or creates) the mapping for the specified attribute of the target type. The transformation expression must be a SQL expression or a PL/SQL function returning the type of the specified attribute of the target type. An attribute number zero must be specified for a scalar target type. If the target type is an ADT, and the attribute_number
is zero, then the expression must be a PL/SQL function returning an object of the target type or a constructor expression for the target type.
DBMS_TRANSFORM.MODIFY_TRANSFORMATION ( schema VARCHAR2(30) name VARCHAR2(30), attribute_number INTEGER, transformation VARCHAR2(4000));
This procedure drops the given transformation.
DBMS_TRANSFORM.DROP_TRANSFORMATION ( schema VARCHAR2(30), name VARCHAR2(30));
Parameter | Description |
---|---|
schema |
Specifies the schema of the transformation |
name |
Specifies the name of the transformation |
|
Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. |
|