Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Mailing Lists ->
Oracle-L ->
Re: Union quries: INTERSECT, MINUS, etc
Re: Union quries: INTERSECT, MINUS, etc
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
Original text of this message