The GET_DDL function fetches the metadata of an object and returns them in DDL.
The GET_xxx functions return the metadata of objects with a single call. The current version of OceanBase Database only supports GET_DDL.
Syntax
FUNCTION GET_DDL (
object_type VARCHAR,
name VARCHAR,
ob_schema VARCHAR DEFAULT NULL,
version VARCHAR DEFAULT 'COMPATIBLE',
model VARCHAR DEFAULT 'ORACLE',
transform VARCHAR DEFAULT 'DDL')
RETURN CLOB;
Parameters
| Parameter | Description |
|---|---|
| object_type | The type of the object to retrieve. The attributes of the object type must be a named object. |
| name | The name of the object. |
| ob_schema | The schema that contains the object. The default value of this parameter is the schema of the caller. |
| version | The version of the metadata. |
| model | The object model of the metadata. |
| transform | Uses XSL-T to convert the output. |