Re: Where 1 = 1

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: jherrick_at_host.ott.igs.net

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: ListGuru_at_fatcity.com (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).