Difference between revisions of "EXECUTE IMMEDIATE"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Lianja command | Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Lianja command | ||
| − | |||
==Syntax== | ==Syntax== | ||
EXECUTE IMMEDIATE <statement> | EXECUTE IMMEDIATE <statement> | ||
| − | |||
==See Also== | ==See Also== | ||
[[SQL DELETE|DELETE]], [[SQL INSERT|INSERT]], [[SQL UPDATE|UPDATE]] | [[SQL DELETE|DELETE]], [[SQL INSERT|INSERT]], [[SQL UPDATE|UPDATE]] | ||
| − | |||
==Description== | ==Description== | ||
The EXECUTE IMMEDIATE command is used to prepare and execute immediately a DELETE, INSERT, or UPDATE SQL statement or any Lianja command. | The EXECUTE IMMEDIATE command is used to prepare and execute immediately a DELETE, INSERT, or UPDATE SQL statement or any Lianja command. | ||
| − | |||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 22: | Line 17: | ||
|- | |- | ||
|} | |} | ||
| − | |||
==Example== | ==Example== | ||
| Line 28: | Line 22: | ||
EXECUTE IMMEDIATE set deleted off | EXECUTE IMMEDIATE set deleted off | ||
</code> | </code> | ||
| − | |||
==Products== | ==Products== | ||
Revision as of 10:12, 11 December 2012
Purpose
Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Lianja 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 Lianja command.
| Keywords | Description |
|---|---|
| statement | The SQL DELETE, INSERT or UPDATE statement, or Lianja command to execute immediately. |
Example
EXECUTE IMMEDIATE set deleted off
Products
Lianja, Lianja Server
