Re: sqlplus scrolling via some pager
From: Bill Meahan <wmeahan_at_ford.com>
Date: 1997/06/27
Message-ID: <33B3DB75.377B_at_ford.com>#1/1
> >: is there a way to tell sqlplus to use the $PAGER for displaying large
> >: tables as it is possible with psql (the monitor of postgresql)?
Date: 1997/06/27
Message-ID: <33B3DB75.377B_at_ford.com>#1/1
Gerhard Moeller wrote:
> >Gerhard Moeller (Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de) wrote:
> >: is there a way to tell sqlplus to use the $PAGER for displaying large
> >: tables as it is possible with psql (the monitor of postgresql)?
set pagesize <number of lines on screen> set pause on
will enable the built-in "pager" of SQL*Plus (rather like "more") -- use the spacebar to get the next page. There is no direct way to use the $PAGER variable or the "paging" program it refers to.
Not very fancy, but it DOES keep large result sets from scrolling by too quickly. CAVEAT: you have to hit the spacebar to get the FIRST page as well.
-- Bill Meahan wmeahan_at_ford.com Ford Motor Company -- End User Support - North America Not an official statement of Ford Motor Company or anyone else except the author.Received on Fri Jun 27 1997 - 00:00:00 CEST