Benefits of dynamic SQL

Using dynamic SQL commands, an application can prepare a “generic” SQL statement once and execute it multiple times. Statements can also contain markers for parameter values to be supplied at execution time, so that the statement can be executed with varying inputs.