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 -> Database Link = UNION??

Database Link = UNION??

From: KC <kchui_at_smtpgw.arms.ohio-state.edu>
Date: 6 Jan 1999 22:42:12 GMT
Message-ID: <01be39c5$74d4db80$c09c9280@hli.arms.ohio-state.edu>


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. Received on Wed Jan 06 1999 - 16:42:12 CST

Original text of this message

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