Use Bind Variables to Help the Outline Check
Oracle versions 7-8
Dynamically building SQL in a host-language string, with the values
of host-language variables pasted into the string, is a bad idea.
Such code might look like this:
There are other reasons to use bind variables. For example, the optimizer may be able to perform bind variable peeking to determine likely values for the variables, improving its choice among execution plans.
So, what is a bind variable? It is a placeholder in a SQL statement
for a host-language variable. Oracle's on-line Ask Tom column
(http://asktom.oracle.com) provides the following example.