Re: simple question about sql*plus

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" <nguyenk1_at_seattleu.edu> 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.
Received on Sat Oct 25 2003 - 02:44:22 CEST