Define all of the SQL statements that are allowed in SQL routines.

 

Syntax

 

<SQL procedure statement> ::=

 

<SQL schema statement> ::=

 

<SQL schema definition statement> ::=

 

<SQL schema manipulation statement> ::=

 

<SQL data statement> ::=

 

<SQL data change statement> ::=

 

<SQL control statement> ::=

 

<SQL transaction statement> ::=

 

<SQL session statement> ::=

 

 


 

Conformance

 

SQL:2003 standard

 

 

 

 

 

 

 

 

 

 

 

NexusDB extensions

-

-

-

-

-

-

-

-

-

-

-

 

-

-

-

-

Core SQL

Feature T651 "SQL-schema statements in SQL routines"

Feature P002-01 "Compound statement"

Feature P002-04 "SQL variable declaration"

Feature P002-05 "Assignment statement"

Feature P002-07 "IF statement"

Feature P002-08 "ITERATE statement"

Feature P002-09 "LEAVE statement"

Feature P002-11 "REPEAT statement"

Feature P002-12 "WHILE statement"

Feature P002-14 "SIGNAL statement"

 

CREATE INDEX statement

DROP INDEX statement

TRY statement

SET PASSWORDS statement