simple question about sql*plus

[khangu]

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.

[mcstock]

you want to use the 'SET FEEDBACK xx' SQL*Plus command ... the default is 6
or more rows

you can type this command at the SQL> prompt each time you log in, or put it
in a 'login.sql' file (you can set up a local or global login.sql -- check
out the docs at http://tahiti.oracle.com

"khangu" <ng******@seattleu.edu> wrote in message
news:b6**************************@posting.google.c om...

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.

[Paul]

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" <ng******@seattleu.edu> wrote in message
news:b6**************************@posting.google.c om...

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.

[gadhiraju]

ng******@seattleu.edu (khangu) wrote in message news:<b6**************************@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@DB01> select * from t;

A B
--------- ---------
19 20
19 20

apps@DB01> set feedback on;
apps@DB01> /

A B
--------- ---------
19 20
19 20

2 rows selected.

apps@DB01> set feedback off;
apps@DB01> /

A B
--------- ---------
19 20
19 20
apps@DB01>