RE: Quick compare of PL/SQL records

  • From: "Knight, Jon" <jknight@xxxxxxxxxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 29 Apr 2005 09:18:26 -0500

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.

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=

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.

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 ?
> source_rec     source_table%rowtype;
> source1_rec     source1_table%rowtype;
> Thanks, Ranko.

Other related posts: