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@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.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: