Re: sqlplus question

Johan,

>We have a table of say a 300 rows. If I do a select * from my_table all
>the
>answers are scrolling of my screen. How can I tell sqlplus to stop after
>
>20 rows and continue if you press a key. Do you have something like
>'more' command in sqlplus ?

How about 'set pause to 20', 'set pause on', 'set pause off'?

• Martin Jesterhoudt
• Martin.Jesterhoudt(replace this by @)usa.net

  ---