Re: Counter rows in cursor using for loop.

From: <screwbai_at_my-deja.com>
Date: Tue, 05 Oct 1999 09:53:52 GMT
Message-ID: <7tchrd$kcq$1@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. The last line doesn't have an 'OR' at the end there I need to test if the cursor has reached the last row and then not print the 'OR'. Having said that I am sure you can come up with something that is much smarter.

Thanks for you response.

In article <939113023.28640.0.nnrp-12.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> It would be interesting to hear why you need
> to take this sort of approach. Having said that,
> I suggest a cursor loop, with a cursor%rowtype
> variable.
>
> Something roughly like:
>
> declare
> cursor C1 is {your select statement}
> prev_row c1%rowtype
> first_row boolean := true;
>
> begin
> for r1 in c1 loop
>
> if first_row then
> first_row := false;
> prev_row := r1;
> else
> {do something with prev_row}
> prev_row := r1;
> end if;
>
> {do the special thing with prev_row}
>
> end loop;
>
> end;
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> screwbai_at_my-deja.com wrote in message <7tc961$f0n$1_at_nnrp1.deja.com>...
> >
> >
> >I want count the number of rows that a cursor contain. Basically I
want
> >to do something with the last row in the cursor.
> >
> >This is what I want to do:
> >for rec in cur
> >LOOP
> >if counter<last
> >then
> >.......
> >else
> >.......
> >end if;
> >counter :=counter + 1;
> >END LOOP;
> >
> >I guess there is no other way to find the value of last than to
> >introduce a second cursor for loop.
> >
> >This is how I want to get to the value of last.
> >
> >last :=0;
> >for rec in cur
> >LOOP
> >last := last + 1;
> >END LOOP;
> >
> >I am fairly happy with this solution. But would be curious if there
is
> >one that would be more elegant.
> >
> >Thanks !!
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 05 1999 - 04:53:52 CDT