Re: trimming the fat from SQL*Plus output

From: Simon Stow <sstow_at_uk.oracle.com>
Date: 1997/09/25
Message-ID: <342A642B.7982@uk.oracle.com>#1/1

Invoke plus via sqlplus -s

Andrea Beam wrote:
>
> Are there any 'set' options that will allow me to go from this:
> $ echo "select count(*) from subscribers;" | sqlplus db/db
>
> SQL*Plus: Release 3.2.2.0.0 - Production on Wed Sep 24 13:59:19 1997
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>
> Connected to:
> Oracle7 Server Release 7.2.2.3.0 - Production Release
> With the parallel query option
> PL/SQL Release 2.2.2.3.0 - Production
>
> SQL>
> COUNT(*)
> ----------
> 89065
>
> SQL> Disconnected from Oracle7 Server Release 7.2.2.3.0 - Production
> Release
> With the parallel query option
> PL/SQL Release 2.2.2.3.0 - Production
>
> To this:
> $ echo "select count(*) from subscribers;" | sqlplus db/db
> COUNT(*)
> ----------
> 89065
>
> Thanks much,
>
> abeam_at_holly.colostate.edu
Received on Thu Sep 25 1997 - 00:00:00 CDT