Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> [Q]How to get row count in select stmt in OCI

[Q]How to get row count in select stmt in OCI

From: jmseo <jmseo2000_at_netsgo.com>
Date: Tue, 26 Oct 1999 10:50:57 +0900
Message-ID: <7v30qj$r3e$1@news2.kornet.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US