The native PL/SQL insert statement in the first example actually generates a recursive SQL statement--' insert into mytestvalues (:1)'--and binds the values on each iteration.

You can use SQL to create, modify, search, and display database information. Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements.

The EXECUTE statement sends dynamic non-query, DBMS-specific SQL statements to the DBMS and processes those statements. In some SAS/ACCESS interfaces, you can issue an EXECUTE statement directly ...