Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> [Q]How to get row count in select stmt in OCI
Hi,
I'm programming with OCI.
To get the select result, it calls oexec() and ofetch().
My problem is that I have to know the result row numbers before calling
ofetch().
I think there would be some data structure that keep statistic information, but I cannot find it.
The easy way is to execute "select count(*).." before executing select
statement,
but it may cost too much. If anybody has an answer for it, please let me
know...
Regards,
Jungmin Seo Received on Mon Oct 25 1999 - 20:50:57 CDT