Re: Comparing Tables

From: The Magnet <art_at_unsu.com>
Date: Fri, 21 Sep 2012 16:48:05 -0700 (PDT)
Message-ID: <a114f287-d753-44e1-95d7-33e26070bbc1_at_v15g2000yqi.googlegroups.com>

On Sep 21, 6:43 pm, John Hurley <johnthehur..._at_gmail.com> wrote:
> 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 ...

Would love to, but this has to be part of a batch cycle...... Received on Fri Sep 21 2012 - 18:48:05 CDT