Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> trimming the fat from SQL*Plus output

trimming the fat from SQL*Plus output

From: Andrea Beam <abeam_at_holly.ColoState.EDU>
Date: 1997/09/24
Message-ID: <60bnt7$75k@holly.ColoState.EDU>#1/1

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 Wed Sep 24 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US