Re: Retrieve data from two databases

sajuars_at_gmail.com wrote:
> Hello ,
>
> I need to make a query to get and compare data from two databases . I
> tried a query with inner join ..but it did not work ...gave me and
> error that the query is not properly ended .
> Can anyone help me in this ?
> I am using oracle 8i .
>
> sars

You are trying to reinvent the wheel. This capability is already part of a built-in package.

Go to Morgan's Library at www.psoug.org and scroll down to DBMS_RECTIFIER_DIFF.

-- 
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