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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Plus question

Re: SQL*Plus question

From: Andy Kent <andykent.bristol1095_at_virgin.net>
Date: 1 Feb 2005 03:10:57 -0800
Message-ID: <1107256257.902414.170860@f14g2000cwb.googlegroups.com>


Many thanks - this works well. I can put everything in a single, simple shellscript this way.

How can I suppress most or all of the spurious output? i.e.:

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production With the Partitioning option
JServer Release 8.1.7.3.0 - 64bit Production

SQL> SQL> SQL> SQL>
DATA



ABCDEF
SQL> 2 old 2: where &flag=0
new 2: where 1=0
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Pro
duction
With the Partitioning option
JServer Release 8.1.7.3.0 - 64bit Production I only really want to see the data and heading.

Andy Received on Tue Feb 01 2005 - 05:10:57 CST

Original text of this message

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