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;