Syntax: FUNCTION get_ddl ( object_type IN VARCHAR2, name IN VARCHAR2, schema IN VARCHAR2 DEFAULT NULL, version IN VARCHAR2 DEFAULT 'COMPATIBLE', model IN VARCHAR2 DEFAULT 'ORACLE', transform IN VARCHAR2 DEFAULT 'DDL') RETURN CLOB; Parameters: object_type - The type of object to be retrieved. name - Name of the object. schema - Schema containing the object. version - The version of the objects' metadata. model - The object model for the metadata. transform - XSL-T transform to be applied. RETURNS: Metadata for the object transformed to DDL as a CLOB. Example: SQL> set pagezie 0 SQL> set long 90000 SQL> select dbms_metadata.get_ddl('TABLE', 'EMP','SCOTT') from dual;