> I think no. Because optimizer creates plan during prepare, when no
> parameter values are specified. And, parsing parameter values is too

complex.

> But, I don't know about
>
> select ... from ...
> where somefield like :param||'%'.
>
> Of course, :param||'%' also can be computed only during execute, but...
>

Wouldn't fly either because the param could be %abc

JAC.