Received: by 10.66.89.163 with SMTP id bp3mr2211967pab.6.1348471062996;
        Mon, 24 Sep 2012 00:17:42 -0700 (PDT)
Path: a8ni19729169pbd.1!nntp.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!newspump.sol.net!xlned.com!feeder3.xlned.com!news.astraweb.com!border5.a.newsrouter.astraweb.com!goblin3!goblin.stu.neva.ru!b.newsfeed.yosemite.net!i.newsfeed.yosemite.net!newsfeed.yosemite.net!news.glorb.com!news2.arglkargh.de!news.mixmin.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail
From: Mladen Gogala <gogala.mla...@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Comparing Tables
Date: Sat, 22 Sep 2012 17:41:42 +0000 (UTC)
Organization: solani.org
Lines: 19
Message-ID: <pan.2012.09.22.17.40.46@gmail.com>
References: <cb932f27-ed7f-4e5c-97fa-afd9327e9a15@n9g2000yqn.googlegroups.com>
Mime-Version: 1.0
X-Trace: solani.org 1348335702 29271 eJwNycEBwCAIA8CVoCbBjiNQ9h/B3ve45KqAKHA4tb4tN5SeTOUemVmbFkj/Iyp75k10HB7gAg7QEMA= (22 Sep 2012 17:41:42 GMT)
X-Complaints-To: abuse@news.solani.org
NNTP-Posting-Date: Sat, 22 Sep 2012 17:41:42 +0000 (UTC)
User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508
	git://git.gnome.org/pan2)
X-User-ID: eJwNxsEBwEAEBMCWiLUoJ87pv4RkXuNG5QnQCV9fjTTN23eJmhA8b/XARrPk3w1C8oxrp5ThAxFyEII=
Cancel-Lock: sha1:YzbEGNGmbBHXvk+yJi8J04iAJmU=
X-NNTP-Posting-Host: eJwNyMEBwCAIA8CVsJCA4yDC/iPYex6Ui+VG0DCYlKqs/nCiRq1dj7rfvxGG3k1ex2ZKht4lDzPREWA=
Bytes: 1931
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

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.com