Re: Dynamic Query

From: Gerard H. Pille <>
Date: Thu, 10 Sep 2009 20:24:18 +0200
Message-ID: <4aa94451$0$2851$>

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

Original text of this message