December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_TRANSFORM.CREATE_TRANSFORMATION
(schema IN VARCHAR2(30),
name IN VARCHAR2(30),
from_schema IN VARCHAR2(30),
from_type IN VARCHAR2(30),
to_schema IN VARCHAR2(30),
to_type IN VARCHAR2(30),
transformation IN VARCHAR(4000));
Transforms from from_schema of from_type to to_schema of to_type using name of schema with transformation expression.
PROCEDURE DBMS_TRANSFORM.MODIFY_TRANSFORMATION
(schema IN
VARCHAR2(30),
name IN
VARCHAR2(30),
attribute_number IN
INTEGER,
transformation IN
VARCHAR(4000));
Modifies the mapping for attribute_number of target type of name of schema with transformation expression.
PROCEDURE DBMS_TRANSFORM.DROP_TRANSFORMATION
(schema IN
VARCHAR2(30),
name IN
VARCHAR2(30));
Drops transformation name in schema.