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.
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.