Re: Dynamic Query
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Thu, 10 Sep 2009 20:24:18 +0200
Message-ID: <4aa94451$0$2851$ba620e4c_at_news.skynet.be>
Date: Thu, 10 Sep 2009 20:24:18 +0200
Message-ID: <4aa94451$0$2851$ba620e4c_at_news.skynet.be>
The Magnet wrote:
>
> Hi,
>
> 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
> anyways.
>
> 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