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

Home -> Community -> Usenet -> c.d.o.server -> Re: comparing two records

Re: comparing two records

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Mon, 22 Jan 2001 02:46:40 GMT
Message-ID: <94g6uf$im3$1@nnrp1.deja.com>

There is a standard SQL statement to do that:

select * from ...
where <where clause for the first record> minus
select * from ...
where <where clause for the second record>

In article <94bmjt$5q0$1_at_news.seed.net.tw>,   "Jennifer Chang" <jchang_at_uxb2b.com> wrote:
> hi,
> is there any built-in procedure that can be called to compare two
 records
> in Oracle ?
> I'm using Oracle 8i for Windows 2000
>
> thank you
>
> Jennifer Chang
>
>

Sent via Deja.com
http://www.deja.com/ Received on Sun Jan 21 2001 - 20:46:40 CST

Original text of this message

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