Overview

Dynamic SQL is a programming feature provided by PL, allowing SQL statements to be generated and executed during the execution of a PL program. This greatly enhances the flexibility of programming.

Dynamic SQL is applicable in the following scenarios:

• When the complete SQL statement cannot be determined during program development.

• For operations that static SQL in PL cannot support, such as DDL.

  Notice

  Generally, static SQL provides better security and efficiency, so dynamic SQL should be used as little as possible.

OceanBase Database PL supports returning complex data types from SQL statements in the following scenarios:

• When dynamic SQL executes a SELECT statement.
• When dynamic SQL executes a DML statement.
• When the OUT attribute is assigned values through the USING clause of EXECUTE IMMEDIATE.