Dynamic Query

From: The Magnet <art_at_unsu.com>
Date: Thu, 10 Sep 2009 10:25:59 -0700 (PDT)
Message-ID: <3eea47e7-3f0f-4a21-8dfd-c29a72111999_at_m11g2000yqf.googlegroups.com>


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...... Received on Thu Sep 10 2009 - 12:25:59 CDT

Original text of this message