Re: Comparing Tables

From: John Hurley <johnthehurley_at_gmail.com>
Date: Fri, 21 Sep 2012 16:43:33 -0700 (PDT)
Message-ID: <e800523b-0f1e-4f7f-8134-282cb24e1d48_at_l14g2000yqo.googlegroups.com>

On Sep 21, 7:29 pm, The Magnet <a..._at_unsu.com> wrote:
> Hi,
>
> I am using this SQL to perform some simple table compares:
>
> data_rec=`sqlplus -s $user/${password} << "EOF"
>   set heading off feedback off verify off timing off
>   SELECT COUNT(*) FROM
>      (SELECT * FROM master_table MINUS SELECT * FROM
> master_table_at_dblink);
>   exit
> EOF`
>
> 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!

Use Toad ... Received on Fri Sep 21 2012 - 18:43:33 CDT