Dynamically prepares, executes, and releases an SQL statement.
The EXECUTE IMMEDIATE statement is a dynamic SQL statement.
Dynamic SQL lets programs accept or generate SQL statements at
run time, in contrast to precompiled statements, which must be
embedded in the program before it is compiled. Unlike embedded
statements, such dynamically executed SQL statements are not
necessarily part of the program's source code, but can be created
while the program is running. Dynamic SQL is useful when you
cannot predict the type of SQL statement your program will need
to process.
The EXECUTE IMMEDIATE statement cannot contain parameter markers.
However, if the statement meets those restrictions and will
be dynamically executed only once, use the EXECUTE IMMEDIATE
statement instead of PREPARE and EXECUTE statements.
Additional Information:
explode
extract