Variable Expressions

A variable expression specifies a host variable with an optional indicator variable. This form of expression can appear only in embedded SQL statements or SQL statements processed in an Oracle Call Interface (OCI) program.

variable_expression::=

Description of the illustration variable_expression.gif

Some valid variable expressions are:

:employee_name INDICATOR :employee_name_indicator_var
:department_location