SET
The SET
statement assigns a value to a declared variable.
Syntax
SET
variable-name
=
proc-expr
Remarks
You must declare variables before you can set them.
SET
is allowed only in stored procedures and triggers.
Examples
The following examples assigns a value of 10 to var1.
SET :var1 = 10;
See Also
CREATE PROCEDURE
DECLARE