Dynamic SQL statements serve to support applications which can only decide at runtime which of the SQL statements is to be executed. For example, a user might want to enter an SQL statement from the terminal and to have it executed at once.
Dynamic statements can also be executed in an ORACLE-compatible way. In such a case, the option sqlmode must be enabled for precompilation (see chapter ANSI).
See also:
Dynamic SQL Statements without Parameters
Dynamic SQL Statements with Parameters
Dynamic SQL Statements with Descriptor