Re: Union quries: INTERSECT, MINUS, etc

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.
Received on Thu Jul 24 2003 - 22:19:45 CDT