The SQL statement EXECUTE IMMEDIATE causes an SQL statement to prepare and execute, dynamically, at run time.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Dynamic SQL statements are embedded in programs and bound before they are executed.
- In Dynamic SQL ,The COMMIT or ROLLBACK statement destroys the prepared statement and the statement need to ...
- Is Prepared statement a precomplied SQL statement?
- Which of the following statement is used for executing dynamic SQL
- What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?
- The given T-SQL statement is executed. What happens?
- Sql injection occurs when
- Bind variables should be used in SQL statements