Dynamically executes a previously prepared statement.
The EXECUTE statement is a dynamic SQL statement. Dynamic SQL
lets programs accept or generate SQL statements at run time,
in contrast to SQL statements that are part of the source code
for precompiled programs or SQL module language procedures.
Unlike precompiled SQL or SQL module language statements, such
dynamically executed SQL statements are not necessarily part of a
program's source code, but can be generated while the program is
running. Dynamic SQL is useful when you cannot predict the type
of SQL statement your program will need to process.
If a program needs to dynamically execute a statement more than
once, the statement should be prepared first with the PREPARE
statement and executed each time with the EXECUTE statement.
SQL does not parse and compile prepared statements every time it
dynamically executes them with the EXECUTE statement.
Additional Information:
explode
extract