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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Gints Plivna Sent: Friday, April 29, 2005 8:14 AM To: ranko.mosic@xxxxxxxxx; 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@xxxxxxxxx> 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 > Thanks, Ranko. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l