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.