Re: # of rows affected by a SQL statement

From: TurkBear <johng_at_mm.com>
Date: Wed, 23 Feb 2000 19:15:29 GMT
Message-ID: <38b43191.4655253@204.181.81.99>

With feedback set to ON, SqlPlus will return the # of rows affected: update,delete,insert,select all tell you how many rows are involved...

jdefreitas7176_at_my-deja.com wrote:

>Hi All.
>
>I was wondering if there was a system variable
>in Oracle that would display the number of rows
>affected by a SQL statement. I don't mean rownum;
>I just want to execute an UPDATE, and then see
>how many rows were affected. Thanks!
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Wed Feb 23 2000 - 13:15:29 CST