Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!proxad.net!newsfeed.stueberl.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!195.29.150.88.MISMATCH!news2.t-com.hr!not-for-mail
From: Cile <cile@hi.htnet.hr>
Newsgroups: comp.databases.oracle.misc
Subject: Re: number of rows in cursor?
Date: Sun, 12 Dec 2004 10:24:54 +0100
Organization: T-Com
Lines: 7
Message-ID: <cph2p5$ntm$1@ls219.htnet.hr>
References: <cpbnnn$qj7$1@ls219.htnet.hr> <1102823267.939293.234900@c13g2000cwb.googlegroups.com>
NNTP-Posting-Host: ao7-m148.net.t-com.hr
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: ls219.htnet.hr 1102843494 24502 195.29.38.148 (12 Dec 2004 09:24:54 GMT)
X-Complaints-To: abuse@t-com.hr
NNTP-Posting-Date: Sun, 12 Dec 2004 09:24:54 +0000 (UTC)
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
In-Reply-To: <1102823267.939293.234900@c13g2000cwb.googlegroups.com>
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:115000

ak_tiredofspam@yahoo.com wrote:
> there is no efficient way, you need to run a COUNT(*) query before.
> What is your problem? Maybe there is another solution other than SELECT
> COUNT(*) ...
> 
I need to send number of steps to outside code. Select count(*) is no 
good for performance. Thanks anyway!