row count for a query BEFORE it starts
From: Robert Andrew Power <robertp_at_carina.csis.dit.csiro.au>
Date: Mon, 6 Sep 1993 05:06:16 GMT
Message-ID: <1993Sep6.050616.11072_at_csis.dit.csiro.au>
Date: Mon, 6 Sep 1993 05:06:16 GMT
Message-ID: <1993Sep6.050616.11072_at_csis.dit.csiro.au>
Using Pro*C cursor to get data can I find out how many rows will be returned for a query before I start getting data? Can this be done in OCI? I don't really want to do a
select count(*) from ...
before each query. I was wondering if ORACLE creates a temporary table corresponding to a query and then selects the info from the temp table. If this is so, ORACLE should know how many rows have been retrieved.
Anyone know the answer?
Robert Power
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
robert.power_at_csis.dit.csiro.au
CSIRO Division of Information Technology
PO Box 664 tel: +61 6 275 0960 Canberra ACT 2601 AUSTRALIA. fax: +61 6 257 1052Received on Mon Sep 06 1993 - 07:06:16 CEST
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++