Re: Counter rows in cursor using for loop.

From: <screwbai_at_my-deja.com>
Date: Tue, 05 Oct 1999 12:23:49 GMT
Message-ID: <7tcqkb$q0t$1@nnrp1.deja.com>

That's very clever. Thanks for sharing that we me and the group !!!

In article <939118162.12436.0.nnrp-06.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> Look at the statement the other way round:
>
> A1.col1 <> b1.col1
> OR a1.col2 <> b1.col2
> ...
> OR a1.colN <> b1.colN
>
> You want a blank for the first line, and
> an OR at the start of every other line
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> screwbai_at_my-deja.com wrote in message <7tchrd$kcq$1_at_nnrp1.deja.com>...
> >I am basically generatting a statement to compare two tables column
by
> >column. The statement to compare two tables looks like this.
> >
> >if
> >A.col1<>B.col1 OR
> >A.co2<>B.col2 OR
> >...
> >A.coN<>B.colN
> >THEN
> >...
> >I am generating the A.col1<>..using a cursor.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 05 1999 - 07:23:49 CDT