Re: SQL*Plus question: number of rows info returned, when?

From: Robert W. Swisshelm <swisshelm_at_lilly.com>
Date: 1997/03/05
Message-ID: <331D581B.37CB_at_lilly.com>#1/1


Sunil Godithi wrote:
>
> are you sure you have not turned feedback option off. If you do, the
> return number of rows are not shown.
> Sunil
> L. Tseng wrote:
> > > I am puzzled about when exacltly a sql statement would return number
 of rows affected

[Quoted]  > info. I get
 >
[Quoted]  >     n rows selected
 >     n rows created
 >     n rows updated
 >
 >   most of the time but not all the time from executing sql statements 
 at SQL*Plus.
 >
 > Any info will be appreciated.
 >
 > Leslie
 

The default setting for FEEDBACK in sqlplus is 6. This means that any INSERT, SELECT, DELETE, or UPDATE that affects 5 or fewer rows will not show the row count.

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com
Received on Wed Mar 05 1997 - 00:00:00 CET

Original text of this message