469,898 Members | 2,101 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

simple question about sql*plus

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
3 3535
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
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
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.

Similar topics

1 post views Thread by Ruben Schoenefeld | last post: by
3 posts views Thread by Peter | last post: by
2 posts views Thread by Ant | last post: by
3 posts views Thread by khangu | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.