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.


Some valid placeholder expressions are:

:employee_name INDICATOR :employee_name_indicator_var

See Also:

Appendix C in Oracle Database Globalization Support Guide for the collation derivation rules for the placeholder expression with a character data type