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
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 statementsat 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.comReceived on Wed Mar 05 1997 - 00:00:00 CET