Re: Getting number of rows fetched on last query

From: <shaji_vps_at_hotmail.com>
Date: Thu, 25 Feb 1999 23:03:16 GMT
Message-ID: <7b4krd$p6f$1@nnrp1.dejanews.com>

Hi,

You can use the SQL%ROWCOUNT to get the number of rows affected by your last query. use a variable to assign the SQL%ROWCOUNT value to it before issuing another query as this will get reset for every query u run.

Shaji.
Shaji_vps_at_hotmail.com

In article <7atpc9$6vg$1_at_news.netvision.net.il>, "Maoz Mussel" <maoz_at_mindcti.com> wrote:
> Hi there,
>
> When running a query from SQL*PLUS, and echo is on, you receive the
> number of rows that has been fetched on the query, e.g.:
> 203 rows selected.
>
> I'm looking for a way for getting this value on runtime, when using other
> access to Oracle than SQL*PLUS (specifically Delphi). Is there any view
> that store this value per session, or other way to access this value?
>
> thanks in advance,
> Maoz
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 25 1999 - 17:03:16 CST