Re: number of deleted rows

"andrija" <ar35644_at_fer.hr> wrote in message news:<9roeli$c72g$1_at_as201.hinet.hr>...
> How can I know how many rows are deleted when I delete them from the stored
> procedure?
> And I dont want to do the 'select count(*)' before deleting. I need
> something like in TOAD, when you delete rows, you get the message 'xyz rows
> deleted', and I bet it doesn't use 'select count(*)' to get that
> information.

use sql%rowcount
example:
delete from table where id >10;
message('number of rows deleted is '||to_char(sql%rowcount));

Adam Received on Wed Oct 31 2001 - 19:01:37 CET