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