Developer Reference : Data Access Methods : SQL Engine Reference : SQL Syntax Reference : SET
 
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