Re: Counting Deleted Row

caliban_at_pacifier.com ¼¶¼g©ó¤å³¹ <364e5c34.22170696_at_NEWS.pacifier.com>...
>Is there a way to count the rows deleted from a table from inside a
>stored procedure?

Yes. You can refer SQL%ROWCOUNT.
for example:

begin

    delete from emp where job='SALESMAN';     dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted.'); end; Received on Sun Nov 15 1998 - 04:22:48 CST