From: paulq@rogers.com   
      
   set feed on   
      
   set feed 6   
   will only show the resulting number if 6 or more rows are generated by your   
   query   
      
   set feed off   
   never tells you how many rows are returned   
      
      
   "khangu"  wrote in message   
   news:b62dcb89.0310241231.7931e8d6@posting.google.com...   
   > Hello!   
   > i am a newbie in oracle database. I have some question about SQL*PLUS   
   >   
   > Currently, i have some table in an oracle database. When i open   
   > SQL*PLUS and type my query: "select * from employee". It display for   
   > me all the record in the database and then it also display how many   
   > record has been selected.   
   > but if i try to do this: "select * from customer" or select any table   
   > it still display all the record in that table but it didn't display   
   > the summary of how many record it has selected in that table. i would   
   > like to enable that feature in all the table that i have. i wonder if   
   > anyone have suggestion for me. thank you ahead for all the response   
   > and suggestion. it helps me a lot. so please send me your suggestion.   
   > all suggestion is appreciated. thank you very much. bye now.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)