Re: sqlplus scrolling via some pager
From: Gerhard Moeller <Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de>
Date: 1997/06/27
Message-ID: <5p0fgh$fla_at_news.Informatik.Uni-Oldenburg.DE>#1/1
Date: 1997/06/27
Message-ID: <5p0fgh$fla_at_news.Informatik.Uni-Oldenburg.DE>#1/1
The problem with the spool solution below is that I would have to type the commands for each SQL-command again and again. What I would like to have is to tell sqlplus to use a $PAGER for any output larger than some thrashold.
Gerhard.
jstrange_at_imtn.dsccc.com (John Strange) wrote:
>spool rpt
> sql stuff here
>spool off
>host ('$PAGER rpt.lst') ;
>host ('rm rpt.lst') ;
>
>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)?
-- Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE OFFIS | | | | | | Tel.: 0441/9722-122 Escherweg 2 | | | | | | Sekr.: 0441/9722-113 oder -101 D-26121 Oldenburg |O|F|F|I|S| Fax: 0441/9722-102Received on Fri Jun 27 1997 - 00:00:00 CEST