Re: Accessing SQL Feedback information

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 08 Sep 2000 19:04:50 +0200
Message-ID: <3t6irs8hmcsemp961o4799qvpj1s5fnb2a@4ax.com>

The number of rows is returned in a communications area. The sql%rowcount is a *pl/sql* construct to be able to return this value. sql*plus most likely reads this value from the communications area. There is no replacement for sql%rowcount in sql*plus.

Regards,

Sybrand Bakker, Oracle DBA

On Thu, 07 Sep 2000 19:53:16 GMT, "Eric Givler" <egivler_at_flash.net> wrote:

>sql*plus probably gets this from sql%rowcount
>
>Dianna Whitt <dgwhitt_at_my-deja.com> wrote in message
>news:8p8r6p$cph$1_at_nnrp1.deja.com...
>> Is there a way to query for the number of rows deleted after a DELETE
>> statement in SQL? I know how to access this in PL/SQL but I don't know
>> about SQL. This would be the info that is displayed in SQL*Plus
>> feedback. Where is SQL*Plus getting it?
>>
>> Thanks for your time,
>> Dianna
>> --
>> ________________________________________
>> Dianna G. Whitt Principal Engineer
>> dwhitt_at_csihq.com 407-676-2923,x413
>> http://www.csi.cc Computer Science Innovations
>>
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
Received on Fri Sep 08 2000 - 12:04:50 CDT