Tuesday, October 21, 2003, 8:05:10 AM, Conner wrote:
CM> The most common cause I've seen for 1=1 is so when
CM> developers are building dynamic where-clause, they
CM> don't need to worry about adding 'where' versus 'and'
CM> to the sql string being constructed.
Here's another use for you to consider. I recently talked to
someone who uses WHERE 1=1 for editing convenience. I asked
him about it once, and he provided the following
explanation:
Just convenience in editing/reading. These queries are
not in a view, they are in a function inside a package,
which returns a REF CURSOR with the results to Java.
Since I use gvim to edit procedures and it has
auto-alignment and auto-repeat, I tend to make all my
predicates "and *" and use "where 1=1" for the only one
that is different. That also means I can cut-and-paste
entire predicate lines in gvim and always have them
conveniently aligned on the same word: "and".
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article,
or send email to [EMAIL PROTECTED] and
include the word "subscribe" in either the subject or body.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Gennick
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
