Re: No of rows affected in a SQL statement?

Thanks for all the replies. the sql%rowcount would do exactly what I wanted to do.

"Kit" <pashwawa_at_hotmail.com> wrote in message news:8ngs1s$j2v4_at_imsp212.netvigator.com...
> 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.
>
>
Received on Thu Aug 17 2000 - 23:55:22 CDT