No of rows affected in a SQL statement?

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 - 09:14:23 CDT