In Dynamic SQL ,The COMMIT or ROLLBACK statement destroys the prepared statement and the statement need to be prepared again.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- The SQL statement EXECUTE IMMEDIATE causes an SQL statement to prepare and execute, dynamically, at run time.
- Dynamic SQL statements are embedded in programs and bound before they are executed.
- Is Prepared statement a precomplied SQL statement?
- Which is the function call ensure that SQL statement is executed?
- Which is the function call ensure that SQL statement is executed?
- In which of the following transaction control commands in SQL is every change performed since the preceding...
- The ___ statement is used to save changes made to a table.
- A transaction is a set of SQL statements between any two COMMIT and ROLLBACK statements.