Assigning Values to Variables

You can assign a value to a variable in these ways:

• Use the assignment operator to assign it the value of an expression.

• Use the SELECT INTO or FETCH statement to assign it a value from a table.

• Pass it to a subprogram as an OUT or IN OUT parameter, and then assign the value inside the subprogram

• Bind the variable to a value.

This section contains:

• Assigning Values to Variables with the Assignment Operator

• Assigning Values to Variables with the SELECT INTO Statement