Re: Dynamic Query
Date: Thu, 10 Sep 2009 20:24:18 +0200
The Magnet wrote:
> We have some applications that put together dynamic queries. One
> thing I noticed is that all of the queries put an UPPER function at
> the end of it, assuming that the value passed will be alphanumeric.
> Although something like UPPER('123') makes no sense, it does it
> Is Oracle smart enough to know this and not execute the function
> call? I ran a simple query and the plan was exactly the same......
How would not executing this function, modify the plan? Received on Thu Sep 10 2009 - 20:24:18 CEST