Re: SQLPLUS format question

From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Mon, 14 Aug 2006 16:07:19 -0400
Message-ID: <9c9b9dc90608141307n17d9a1f2h842ec3b9f335494b@mail.gmail.com>

Johan,

The issue is that the TERMOUT command does not turn off output from interactive commands:

"To spool output generated by commands in a script without displaying the output
on the screen, use SET TERMOUT OFF. SET TERMOUT OFF does not affect output from commands that run interactively"

Thus the problem is that you need to put your entire SQLPLUS command script in a file and then run the file. So when you run the following file:

set ECHO OFF
set TERMOUT OFF
set FEEDBACK OFF
set VERIFY OFF
set PAGESIZE 0
set LINESIZE 80
set HEADING OFF
SPOOL c:\output.sql
select 'SELECT * FROM DUAL;' from dual
/
spool off
set echo on
set termout on
start c:\output.sql

You get this output:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> start c:\test.sql
SQL> SELECT * FROM DUAL;
X

SQL>
SQL> start c:\test.sql
SQL> set ECHO OFF
SQL> start c:\output.sql
SQL> SELECT * FROM DUAL;

X
SQL> On 8/14/06, Jared Still <jkstill_at_gmail.com> wrote:
>
> On 8/14/06, Johan Muller <johan.muller_at_gmail.com> wrote:
> >
> > Run the following query , trying to build a dynamic sql statement, but
> > CANNOT suppress the statement itself from spooling (Redhat EL 4/Ora
> > 10.1.3):
> >
> >
>
> Output from 10.1.0.4 on Linux:
>
> SELECT
> FROM ALARM_HIST_TBL;
>
> Have you searched ML for bugs?
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

-- 
Rumpi Gravenstein

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 14 2006 - 15:07:19 CDT