RE: Number of records

What do you need the count for? It's a waste of time. You never get the
count until you get to the last record. And if you get it, it may not be
stilll the same if someone else have added records while you are doing your
processing.

-----Original Message-----
From: Naveed [mailto:[email protected]]
Sent: Friday, February 28, 2003 7:53 AM
To: Oracle
Subject: [oracle] Number of records


Hi Everybody,
 
I want to count the number of records that will retrieve against
EXECUTE_QUERY built in. There is a COUNT_QUERY built in , which give the
message how many records will return but I want to store this value
(number of records) in a variable. How can I do this, Is there any other
built in which can we use??
 
Your help will be much appreciated.
 
Best Regards
Naveed

=======================================================
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please notify the sender or the
System Administrator at [email protected] .The unauthorized use,
disclosure or alteration of this message is strictly forbidden. Moreover,
this message has been scanned for the presence of computer viruses.


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].