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

In article <5fiacn$kke_at_nntp1.u.washington.edu>, lesliet_at_u.washington.edu (L. Tseng) writes:
|>
|> 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

with the set command in sqlplus

     FEED[BACK] {6|n|OFF|ON}
         shows the number of records returned by a query when at n or more
         records are selected.  ON sets n to 1.  Zero is the same as OFF.

I believe 6 is the default.

HTH

-- 
Bill Kannawin (303)844-1479 kannawin_at_osmre.gov|
Technical Information Processing System       |
US Office of Surface Mining; 1999 Broadway,   |
Suite 3320, Denver, Colorado 80202            |