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