Re: Diff between the results returned by two ref cursors

From: Steve Baldwin <stbaldwin_at_multiservice.com>
Date: Wed, 6 Jan 2010 15:04:29 +1100
Message-ID: <d282b3ab1001052004w67cd3c27q29a7a6624afceacf_at_mail.gmail.com>



Actually, it should really be :

(
 select '1_not_in_2' id, t.* from table(pipe_func_1) t  minus
 select '1_not_in_2' id, t.* from table(pipe_func_2) t )
union all
(
 select '2_not_in_1' id, t.* from table(pipe_func_2) t  minus
 select '2_not_in_1' id, t.* from table(pipe_func_1) t )

Steve

On Wed, Jan 6, 2010 at 2:50 PM, Steve Baldwin <stbaldwin_at_multiservice.com> wrote:
> How about writing two pipelined functions - one for each ref cursor.
>
> Then it's a simple matter of :
>
> select * from table(pipe_func_1)
> minus
> select * from table(pipe_func_2)
>
> Hope this helps.
>
> Steve
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 05 2010 - 22:04:29 CST

Original text of this message