Difference between revisions of "EXECUTE IMMEDIATE"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
| − | Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital | + | Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital command |
| Line 16: | Line 12: | ||
==Description== | ==Description== | ||
| − | The EXECUTE IMMEDIATE command is used to prepare and execute immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital | + | The EXECUTE IMMEDIATE command is used to prepare and execute immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital command. |
| Line 23: | Line 19: | ||
!Keywords||Description | !Keywords||Description | ||
|- | |- | ||
| − | |statement||The SQL DELETE, INSERT or UPDATE statement, or | + | |statement||The SQL DELETE, INSERT or UPDATE statement, or Recital command to execute immediately. |
|- | |- | ||
|} | |} | ||
| Line 30: | Line 26: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | EXECUTE IMMEDIATE set deleted off | + | EXECUTE IMMEDIATE set deleted off |
</code> | </code> | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
Latest revision as of 11:29, 24 December 2009
Purpose
Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital command
Syntax
EXECUTE IMMEDIATE <statement>
See Also
Description
The EXECUTE IMMEDIATE command is used to prepare and execute immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital command.
| Keywords | Description |
|---|---|
| statement | The SQL DELETE, INSERT or UPDATE statement, or Recital command to execute immediately. |
Example
EXECUTE IMMEDIATE set deleted off
Products
Recital, Recital Server
