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@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

 > info. I get
 >
 >     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 CST