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.
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
