Re: Comparing Tables
From: The Magnet <art_at_unsu.com>
Date: Fri, 21 Sep 2012 16:36:30 -0700 (PDT)
Message-ID: <ba888490-a95c-43c4-b851-05db67a9af1c_at_t4g2000vba.googlegroups.com>
On Sep 21, 6: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!
Date: Fri, 21 Sep 2012 16:36:30 -0700 (PDT)
Message-ID: <ba888490-a95c-43c4-b851-05db67a9af1c_at_t4g2000vba.googlegroups.com>
On Sep 21, 6: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!
Perhaps I should tell a bit more........the tables exist in different databases, as you can see by the link. There are several regular columns in the table, then a few nested tables. I want to compare the two tables to make sure they contain the exact same data.
Help! Received on Fri Sep 21 2012 - 18:36:30 CDT