Hi Ed
It's useful in when generating DML on the fly and you
don't have the inclination or the ability to determine
if there are any other user-supplied (or otherwise generated)
predicates or where/when the last predicate has been
found. i.e.
1) Generate first part of Select (select foo from bar)
2) determine if there is at least one predicate and output 'WHERE'
3) loop thru predicates (from another table or a list box
construct)
4) tack on the 'AND 1=1;' if you did step 3
5) prepare and execute the DML
HTH
Jeff Herrick
Jeff Herrick & Associates
On Thu, 25 Oct 2001, Ed Bittel wrote:
> I was monitoring a load test of my company's new
> application when I came across something interesting.
> One of the more monstrous queries had the following as
> part of its WHERE clause: 'AND 1 = 1'
>
> Has anyone seen this used before? What is it supposed
> to achieve?
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeff Herrick
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
