The procedure language in NexusDB SQL consists of a set of control statements that extends the SQL language with compound statement blocks (BEGIN .. END), SQL variable declarations, conditional statements, iterating statements and error handling. This functionality adds computational completeness to NexusDB SQL and makes it a fully programmable database language, which is particularly useful in the definition of triggers, user-defined procedures and user-defined functions.

 

 


 

CALL statement

RETURN statement

Compound statement

DECLARE variable statement

SET statement

IF statement

ITERATE statement

LEAVE statement

REPEAT statement

WHILE statement

SIGNAL statement

TRY statement