EXECUTE IMMEDIATE
The EXECUTE IMMEDIATE statement in SQL Script dynamically executes certain SQL statements.
Syntax
EXECUTE IMMEDIATE <valueExpr>
Remarks
• The <valueExpr> must evaluate to a string type (CHAR or VARCHAR). The text in this string is executed as SQL.
• This form of dynamic SQL is useful mainly for INSERT, UPDATE, and DELETE statements. It has no value to SELECT, because the selections cannot be assigned to anything. See the OPEN FOR statement used in
OPEN for information about how to perform a dynamic SELECT.
Example
PROCEDURE drop (IN table_name VARCHAR)
BEGIN
DECLARE sql_stmt VARCHAR;
SET sql_stmt
= CAST(CONCAT(‘DELETE FROM ‘, table_name) AS VARCHAR);
EXECUTE IMMEDIATE sql_stmt;
END