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

Home -> Community -> Usenet -> c.d.o.tools -> select from schema 1 minus select from schema 2

select from schema 1 minus select from schema 2

From: Jeff Kish <jeff.kish_at_ait-mmii.com>
Date: Thu, 16 Nov 2000 10:38:10 -0500
Message-ID: <fnv71t4jad07g9el90hlaa2m5hiqc7acbp@4ax.com>

I am using Pro-c (and need to know if this is possible), but this could be extended to a general question I guess.

Is it possible to create a result set from selecting from a table in one schema and minus'ing a select of identical column types from a table in another schema?

Thanks
Jeff
e-mail replies are appreciated. Received on Thu Nov 16 2000 - 09:38:10 CST

Original text of this message

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