OraFAQ Forum: SQL & PL/SQL » Counting results from a loop (merged 4)

Home » SQL & PL/SQL » SQL & PL/SQL » Counting results from a loop (merged 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Counting results from a loop (merged 4) [message #420004]

Wed, 26 August 2009 08:53

GuestUser32
Messages: 26
Registered: August 2009

Junior Member

Hi

I have a for loop in my procedure.
How can I count the results from this loop?
I need to know how many records it went through.

Thanks

[Updated on: Wed, 26 August 2009 09:02] by Moderator

Report message to a moderator

Re: Counting results from a loop [message #420008 is a reply to message #420004]

Wed, 26 August 2009 08:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How can I count the results from this loop?
count := count+1;

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

Report message to a moderator