Difference between revisions of "EXECUTE IMMEDIATE"

From Lianjapedia
Jump to: navigation, search
m (1 revision: SQL)
m (Text replace - "Recital" to "Lianja")
Line 1: Line 1:
 
==Purpose==
 
==Purpose==
Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital command
+
Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Lianja command
  
  
Line 12: 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 command.
+
The EXECUTE IMMEDIATE command is used to prepare and execute immediately a DELETE, INSERT, or UPDATE SQL statement or any Lianja command.
  
  
Line 19: Line 19:
 
!Keywords||Description
 
!Keywords||Description
 
|-
 
|-
|statement||The SQL DELETE, INSERT or UPDATE statement, or Recital command to execute immediately.
+
|statement||The SQL DELETE, INSERT or UPDATE statement, or Lianja command to execute immediately.
 
|-
 
|-
 
|}
 
|}
Line 31: Line 31:
  
 
==Products==
 
==Products==
Recital, Recital Server
+
Lianja, Lianja Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 
[[Category:Commands]]
 
[[Category:Commands]]

Revision as of 12:56, 7 December 2012

Purpose

Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Lianja command


Syntax

EXECUTE IMMEDIATE <statement>


See Also

DELETE, INSERT, UPDATE


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