NexusDB Manual V3 > SQL Reference > SQL Statements > Control Statements
Specify a statement block.
Syntax
<compound statement> ::=
<local declaration list> ::= { <SQL variable declaration> ; }...
<SQL statement list> ::= { <SQL procedure statement> ; }...
Usage
The Compound statement is used to specify a sequence of SQL procedure statements inside a BEGIN..END block.
Notes
Examples
DROP FUNCTION IF EXISTS dummyFunc; CREATE FUNCTION dummyFunc () RETURNS DOUBLE PRECISION BEGIN DECLARE v1, v2 DOUBLE PRECISION; SET v1 = 25; SET v2 = 4; RETURN v1 * v2; END; SELECT dummyFunc FROM #dummy;
Conformance
|
© Nexus Database Systems Pty Ltd.