Re: Compare a table to itself

DA Morgan wrote:
> Newkid wrote:
> > Hi there!
> >
> > Please guide me how to compare a table to itself. Problem is like this:
> >
>
> Use the DBMS_RECTIFIER_DIFF built-in package. It is documented at
> http://tahiti.oracle.com and there are demos in Morgan's Library
> at www.psoug.org.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

That looks like an interesting package - always looking for better ways to produce output.

The search feature in the 10g R2 online documentation took me here: http://www.oracle.com/pls/db102/search?remark=quick_search&word=DBMS_RECTIFIER_DIFF+&tab_id=

First link lead me to this page:
http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_recdif.htm "The DBMS_RECTIFIER_DIFF package provides an interface used to detect and resolve data inconsistencies between two replicated sites."

And then to this page:
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14227/rarmanage.htm "Oracle Database Advanced Replication Management API Reference 10g Release 2 (10.2)"

Is this an Enterprise Edition only package (Advanced Replication)? This reminds me of a couple books that I read about four years ago that discussed the merits of virtual private databases to help hide information in the database from a group of database users, and partitioning to improve performance. The books that discuss these features rarely discuss that the features require the Enterprise Edition of Oracle, or the Enterprise Edition And the purchase of an additional feature.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Sat Jul 22 2006 - 18:20:42 CDT