Re: No of rows affected in a SQL statement?

From: <steveorr_at_my-deja.com>
Date: Thu, 17 Aug 2000 17:00:35 GMT
Message-ID: <8nh5n5$7j6$1@nnrp1.deja.com>

set feedback on

In article <8ngs1s$j2v4_at_imsp212.netvigator.com>, "Kit" <pashwawa_at_hotmail.com> wrote:
> I have been trying to get the number of rows affected from a SQL
statment
> without issuing another
> statment to do a count(*), any help will be appreciated.
>
> For example, if I do the following SQL, is it possible to get the
count(*)
> after the SQL is run?
>
> insert into table_a
> select col_a, col_b from table_b
> where col_a > 1000;
>
> count(*)?
>
> I have not found any reference in Oracle documentation that can be
done but
> I see the front end
> programs (TOAD for one) can display the number of rows affectred, so
I bet
> there must be way to do
> that.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 17 2000 - 12:00:35 CDT