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.