Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> trimming the fat from SQL*Plus output
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