By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,334 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,334 IT Pros & Developers. It's quick & easy.

simple question about sql*plus

P: n/a
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.
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.


Jul 19 '05 #2

P: n/a
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.

Jul 19 '05 #3

P: n/a
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>
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.