Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: Counter rows in cursor using for loop.

Re: Counter rows in cursor using for loop.

From: John Chiu <johnc_at_relsol.com>
Date: Tue, 05 Oct 1999 06:32:35 -0400
Message-ID: <37F9D3C3.25DA3E40@relsol.com>

Why don't you declare your cursor as select ......... order by ..... desc, then fetch the first row in the cursor. that's it.

John Chiu
ocp Received on Tue Oct 05 1999 - 05:32:35 CDT

This message: [ Message body ]
Next message: Chris Forlano: "ORA-01489: result of string concatenation is too long"
Previous message: John Chiu: "Re: dropping multiple tables belonging to a user"
In reply to: screwbai_at_my-deja.com: "Counter rows in cursor using for loop."
Next in thread: Kenneth C Stahl: "Re: Counter rows in cursor using for loop."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US