OraFAQ Forum: SQL & PL/SQL » How to get Record Count?

Home » SQL & PL/SQL » SQL & PL/SQL » How to get Record Count?

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

How to get Record Count? [message #41079]

Thu, 21 November 2002 16:13

Chanti
Messages: 1
Registered: November 2002

Junior Member

Hello all,
I am new to this, I have a simple cursor that is a select statement, how can I get the number of rows this query returned?
Cursor myCur is Select * from temp;
Open myCur
Fetch myCur

Close myCur;

thanks all

Report message to a moderator

Re: How to get Record Count? [message #41081 is a reply to message #41079]

Thu, 21 November 2002 16:57

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

The easiest way is to have a counter inside the loop (I'm assuming there is a loop - your example did not show it).

If there is no loop, you can examine mycur%found to see if a single row was fetched or not.

Report message to a moderator

Previous Topic:	spooling
Next Topic:	Re: Create View with selective concatenation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 06 12:24:11 CDT 2024