Quick compare of PL/SQL records 2005-04-29 - By Knight, Jon
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@(protected) [mailto:oracle-l-bounce@(protected)]
On Behalf Of Gints Plivna
Sent: Friday, April 29, 2005 8:14 AM
To: ranko.mosic@(protected); 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@(protected)> 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
|
|
