Re: sqlplus question

Use "set pause on"....

Johan den Boer <jj.den.boer_at_hccnet.nl> wrote:

>This is a multi-part message in MIME format.>--------------DB1C3EC1FFC7D636041C1155
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>Hello,
>
>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 ?
>
>Johan den Boer
>
>jj.den.boer_at_hccnet.nl
>
>--------------DB1C3EC1FFC7D636041C1155
>Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
>Content-Transfer-Encoding: 7bit
>Content-Description: Card for Johan den Boer
>Content-Disposition: attachment; filename="vcard.vcf"
>
>begin: vcard
>fn: Johan den Boer
>n: den Boer;Johan
>email;internet: jj.den.boer_at_hccnet.nl
>x-mozilla-cpt: ;0
>x-mozilla-html: FALSE
>version: 2.1
>end: vcard
>
>
>--------------DB1C3EC1FFC7D636041C1155--
>
Received on Sun May 09 1999 - 22:49:58 CDT