SQL statements that are known at compile time
The simplest type of dynamic SQL to execute is one for
which you know both of the following items:
- The structure of the SQL statement to be executed, including information like the statement type and the syntax of the statement
- The number and data types of any data that passes between the program and the database server