Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Quick compare of PL/SQL records
Yes, I know what manual says - that's why I am posting the question here.=
=20
The thing is, I need to compare about 100 types of records with dozens of=
=20
attributes each. I would like to be able to avoid field level
comparison and do it
on record level.
rm=20
On 4/29/05, Gints Plivna <gints.plivna_at_gmail.com> wrote:
> Manual says:
> Comparing Records
> Records cannot be tested for nullity, or compared for equality, or inequa=
lity.
>=20
> 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.
>=20
> http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10807/05_co=
lls.htm#i20716
>=20
> 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 ?
> >
> > source_rec source_table%rowtype;
> > source1_rec source1_table%rowtype;
> >
> > Thanks, Ranko.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 29 2005 - 09:37:43 CDT