The way to get Oracle to reuse the execution plans for "the statements having different hard coded value in where clause"
there should use bind variables.
Bind variables are «substitution» variable...
Aarti
Jan 15th, 2014
Bind variable is session specific variable. It is declared using variable keyword. Bind variable cant be used in named block. It cant have default value.