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 placeholder_expression.gif follows]
Description of the illustration ''placeholder_expression.gif''

Some valid placeholder expressions are:

:employee_name INDICATOR :employee_name_indicator_var
:department_location