Re: simple question about sql*plus

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" <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:42:29 CEST