Re: Counter rows in cursor using for loop.

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.
Received on Tue Oct 05 1999 - 05:08:43 CDT