On Oct 1, 5:03 pm, csn..._at_gmail.com wrote:
> > It's more fundamental than that, even. These two statements are
> > different as far as parsing is concerned:
>
> > SELECT * FROM emp WHERE ename = l_variable;
>
> > select * from EMP where ENAME = L_VARIABLE;
>
> The parsing would not have changed the plan, but the bind variable
> peeking may have - in which case it would not have been a new problem.
and bind variable peeking takes place when? Rhetorical question to
which the answer tends to be - when you don't want it to - but
certainly when hard parsing as when, for example a sql prettifier
happens to your code.
Received on Mon Oct 01 2007 - 15:26:42 CDT
