Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Database Link = UNION??

Re: Database Link = UNION??

From: Eugene Gardner <Gene_at_VaxMan.prestel.co.uk>
Date: Thu, 07 Jan 1999 18:12:56 GMT
Message-ID: <3694db67.25606089@news.prestel.co.uk>


There is no connection between these two. A database link is a string stored in the database which enables connection to another (possibly remote) database without having to know the schema name or password, or perhaps to save on convoluted keystrokes.

The UNION statement is a set operator which takes the results of two queries and combines them to form one result in which duplicate results are eliminated.

I suggest you check out the MINUS operator. If you still have problems post the syntax of what you are trying to this newsgroup together with a sample data and required results.

Eugene (Unemployed).



"KC" <kchui_at_smtpgw.arms.ohio-state.edu> wrote:

> I need some clarification: Is a database link the same as a UNION? I'm
> trying to run several SELECT query statements between database 'A' and the
> database link (which includes database 'A') and I need to return those
> values that are *not* present in database 'A', just values in the other
> database. I've tried various statements using 'not in' and 'minus', but
> it's still returning values from 'A'. Any advice would be helpful.
> Thanks.
>
>

Eugene Gardner.
Oracle Certified dba available for hire on NT or VMS platforms. Received on Thu Jan 07 1999 - 12:12:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US