Re: simple question about sql*plus

nguyenk1_at_seattleu.edu (khangu) wrote in message news:<b62dcb89.0310241231.7931e8d6_at_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.

apps_at_DB01> select * from t;

        A B
--------- ---------

       19        20
       19        20

apps_at_DB01> set feedback on;
apps_at_DB01> /

        A B
--------- ---------

       19        20
       19        20

2 rows selected.

apps_at_DB01> set feedback off;
apps_at_DB01> /

        A B
--------- ---------

       19        20
       19        20