Can you get COUNT and RESULTS at same time?

To all gurusI

     am writing a database application for the web using PLSQL and Oracle. When I do a search, I would like the count of total records found as well as the search results. The ROWCOUNT tells you only the count of rows read so far. The only two approaches I have:

1. Do two queries, one with count, the second with results.
2. After I display me first 20 records, continue looping through the results cursor until the end and getting the count.

    Clearly, both these approaches are not optimal. There SHOULD be a way to do this: some function or hidden variable, but I can't find it.

      Please help.

				Thanks in advance,
				David Diano

-- 


************************************************

*               Diano Consulting               *
*  http://www.diano.com   **   dave_at_diano.com  *
* "When it has to be right the first time."    *


************************************************