Dynamic SQL is a PL programming capability that allows statements to be generated and executed during the execution of a PL program, achieving high flexibility in programming.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
The following describes the application scenarios of dynamic SQL statements:
Complete SQL statements cannot be determined during programming.
Required operations, such as DDL operations, are not supported by static SQL statements.
Notice
Generally, static SQL statements provide higher security and efficiency. Therefore, we recommend that you do not use dynamic SQL statements unless necessary.