Help Center> Data Warehouse Service> Developer Guide> Stored Procedures> Basic Statements> Assignment Statement
View PDF

Assignment Statement

Syntax

Figure 1 shows the syntax diagram for assigning a value to a variable.

Figure 1 assignment_value::=

The above syntax diagram is explained as follows:

  • variable_name indicates the name of a variable.
  • value can be a value or an expression. The type of value must be compatible with the type of variable_name.

Examples

1
2
3
4
5
6
7
 
DECLARE
    emp_id  INTEGER := 7788; --Assignment
BEGIN
    emp_id := 5; --Assignment
    emp_id := 5*7784;
END;
/
Parent topic: Basic Statements