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 -> Re: select from schema 1 minus select from schema 2

Re: select from schema 1 minus select from schema 2

From: Jeff Kish <jeff.kish_at_ait-mmii.com>
Date: Thu, 16 Nov 2000 15:42:43 -0500
Message-ID: <1lh81to1c8gr1dvlei3m03cqgk1nqhi15o@4ax.com>

Almost forgot.. the schemas may be in separate instances (I knew I forgot something that made this non trivail).

On Thu, 16 Nov 2000 10:38:10 -0500, Jeff Kish <jeff.kish_at_ait-mmii.com> wrote:

>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 - 14:42:43 CST

Original text of this message

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