The EXEC_DDL_STATEMENT procedure is used to execute a specified DDL statement.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
DBMS_UTILITY.EXEC_DDL_STATEMENT (
parse_string IN VARCHAR2);
Parameters
Parameter |
Explanation |
|---|---|
| parse_string | The DDL statement to be executed. |
Usage instructions
The EXEC_DDL_STATEMENT procedure provides a way to execute DDL statements in PL/SQL. It is similar to EXECUTE IMMEDIATE, but is called through the DBMS_UTILITY system package. This procedure does not return any value; it completes the DDL operation upon successful execution, or throws an exception on failure.
Examples
BEGIN
DBMS_UTILITY.EXEC_DDL_STATEMENT('CREATE TABLE test_table (id NUMBER, name VARCHAR2(50))');
END;
/