Re: Union quries: INTERSECT, MINUS, etc

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Fri, 25 Jul 2003 02:42:15 -0700 (PDT)
Message-Id: <26013.339584@fatcity.com>

not very slick but I used MINUS yesterday to find parents with no children so as to purge them....

we do this a lot in this 3rd party app. RI is sketchy at best and the app blows up if childless parents exists

• jkstill_at_cybcon.com wrote:
  >
  > Jonathan,
  >
  > I've used MINUS heavily in sql scripts and pl/sql
  > to determine the differences in schemas: both
  > structure and data.
  >
  > Of interest to DBA's and developers, and least when I
  > did it it was for the developers.
  >
  > Jared
  >
  >
  > On Thu, 24 Jul 2003, Jonathan Gennick wrote:
  >
  > > I'm doing research for an article on union queries. I'm
  > > interested in finding examples of problems that were solved
  > > using UNION, UNION ALL, INTERSECT, or MINUS, with the latter
  > > two being of special interest because I don't see them used
  > > very often. If you can think of an interesting problem
  > > you've solved using one of these keywords, I'd love to hear
  > > about it.
  > >
  > > Best regards,
  > >
  > > Jonathan Gennick --- Brighten the corner where you are
  > > http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com
  > >
  > > 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 Oracle-article-request_at_gennick.com and
  > > include the word "subscribe" in either the subject or body.
  > >
  > >
  >
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.net
  > --
  > Author:
  > INET: jkstill_at_cybcon.com
  >
  > 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: 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).
  

  ---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software Received on Fri Jul 25 2003 - 04:42:15 CDT