Re: Comparing Tables
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 22 Sep 2012 17:41:42 +0000 (UTC)
Message-ID: <pan.2012.09.22.17.40.46_at_gmail.com>
On Fri, 21 Sep 2012 16:29:48 -0700, The Magnet wrote:
Date: Sat, 22 Sep 2012 17:41:42 +0000 (UTC)
Message-ID: <pan.2012.09.22.17.40.46_at_gmail.com>
On Fri, 21 Sep 2012 16:29:48 -0700, The Magnet wrote:
>
> However, one of the table a complex data type, with nested tables. I
> cannot use the above method on nested tables. Does anyone know a good
> set of code to compare 2 identical tables, that contain nested tables?
>
> Thanks!
Dump both tables into flat files and compute MD5 sum or sha1sum. The latter is 160 bit, but there is also a 512 bit version, in sha512sum.
-- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.comReceived on Sat Sep 22 2012 - 12:41:42 CDT