Re: Quick compare of PL/SQL records

  • From: Gints Plivna <gints.plivna@xxxxxxxxx>
  • To: ranko.mosic@xxxxxxxxx, Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 29 Apr 2005 16:14:00 +0300

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

Other related posts: