Re: oracle: get number of rows from a select statement

Hello Peter, On 11-Sep-00 14:07:47, you wrote: >as in mysql_num_rows($resultset) >how do you get the number of rows from a select statement in oracle? You may want to use Metabase. It will count the result rows for you with a single function call (MetabaseNumberOfRows) and you still be able to fetch result data normally after that. This is not recommended for result sets with a large number of rows. See the explanation for this and possible alternatives in Metabase documentation. Metabase is a free PHP database abstraction package that you may find here: http://phpclasses.UpperDesign.com/browse.html/package/20 Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --