Updated at: 2022-08-03 GMT+08:00

Assignment Statement


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.


DECLARE emp_id INTEGER := 7788; --Assignment BEGIN emp_id := 5; --Assignment emp_id := 5*7784; END; /