Placeholder Expressions

A placeholder expression provides a location in a SQL statement for which a third-generation language bind variable will provide a value. You can specify the placeholder expression 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.

placeholder_expression::=

Description of the illustration placeholder_expression.gif

Some valid placeholder expressions are:

:employee_name INDICATOR :employee_name_indicator_var
:department_location