EXECUTE IMMEDIATE ──┬─> statement-string ──┬─> typebox (;)


                     └─> parameter ─────────┘

Additional information available:

More Informationstatement stringparameter

 EXECUTE IMMEDIATE dynamically prepares and executes an SQL
 statement.  EXECUTE IMMDEDIATE is a dynamic SQL statement and
 can be used only in precompiled programs or as part of an SQL
 module language procedure.  It cannot be used in interactive
 SQL.

 In EXECUTE IMMEDIATE, the SQL statement cannot be a SELECT
 statement or contain parameter markers.  However, if the
 statement meets those restrictions and will be dynamically
 executed only once, use EXECUTE IMMEDIATE instead of PREPARE and
 EXECUTE statements.

 Specifies the SQL statement to be prepared and executed
 dynamically.  You either specify the statement string directly
 in a quoted character string literal or in a parameter that
 contains the statement string.

 Specifies the SQL statement to be prepared and executed
 dynamically.  You either specify the statement string directly
 in a quoted character string literal or in a parameter that
 contains the statement string.