Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus question
"Sunil Pant" <spant_at_eline.com> wrote in message
news:BEDE7.3105$Le.75944_at_sea-read.news.verio.net...
> I've a big table and when I do 'select' on that, the display just rolls
> forward and I can just view the last page. Is there a way to view the
> result set one page at a time.
>
> Thanks,
> SP
>
>
set pagesize 24
set pause on pause "Press ENTER to continue"