Re: Number of records returned by query

Yes, but how do you capture the value that COUNT_QUERY returns in PL/SQL???

Jomarlen wrote in message
<1998040720272501.QAA15516_at_ladder03.news.aol.com>...
>> One<BR>
>>solution is to use LAST_RECORD and then get QUERY_HITS. Would be nice
 to<BR>
>>know if there is a more elegent solution
>
>There is - the built-in COUNT_QUERY.
>
>John
>
>John
>-------------------------------
>John C. Lennon
>Utility Partners Inc.
>Las Vegas
>
>Web Site: http://members.aol.com/jomarlen/
>
>The views expressed in this message
>are those of the author and not
>necessarily those of U.P.
>and/or its employees.
Received on Tue Apr 07 1998 - 00:00:00 CEST