Dynamic SQL Statement Types

There are four types of dynamic SQL statement:

Dynamic SQL Statement Type Perform Queries? Return Data?
Execute a statement once No No, can only return success or failure
Execute a statement more than once No No, can only return success or failure
Select a given list of data with a given set of selection criteria Yes Yes
Select any amount of data with any selection criteria Yes Yes

These types of dynamic SQL statement are described more fully below.