Title: RE: Stupid Bind Variable question
Hi,
I suggest the following:
- If a literal is always going to be the same value than it is marginal whether you use a bind variable for this.
- I'm not sure why you are using the to_char to_date functions? You should be able to create a
Alan Davey wrote:
>
> In any given SQL statement, do I need (or should I :^) ) create a bind variable for
>every literal value even if it is one of the following cases:
>
> 1) substring in a substr function
> 2) date/time format mask used in to_char or to_date function
> 3) comparison value
In any given SQL statement, do I need (or should I :^) ) create a bind variable for
every literal value even if it is one of the following cases:
1) substring in a substr function
2) date/time format mask used in to_char or to_date function
3) comparison value in a decode/case statement (not