RE: Quick compare of PL/SQL records

You might consider inserting your record definitions into a table, then generating several comparison functions from it. Stick 'em all in a package to keep the database clean.

Thanks,
Jon Knight

 -----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gints Plivna

Sent:	Friday, April 29, 2005 8:14 AM
To:	ranko.mosic_at_gmail.com; Oracle-L
Subject:	Re: Quick compare of PL/SQL records

Manual says:
Comparing Records
Records cannot be tested for nullity, or compared for equality, or inequali= ty.

If you want to make such comparisons, write your own function that accepts two records as parameters and does the appropriate checks or comparisons on the corresponding fields.

http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10807/05_coll= s.htm#i20716

On 4/29/05, Ranko Mosic <ranko.mosic_at_gmail.com> wrote:
> How do I compare two separatelly defined PL/SQL records without
> referencing each and every field ?

>=20


> source_rec     source_table%rowtype;

> source1_rec     source1_table%rowtype;

>=20

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l