Re: SqlPlus report keeps outputting the SQL statement
Date: Thu, 23 Aug 2001 20:19:49 +0200
Message-ID: <9m3doe$mrk$1_at_news.kolumbus.fi>
> well he's not wrong ...
>
> however:
> set echo offrt
> set pagesize 0
> set feedback off
> set termout off
> spool yourfile
> select ...
>
> Hth
> Thomas
Thank You, Thomas, but I already have those settings. Sorry Steve, I know You ment well...
There's something weird in this. I created a quick-and-dirty version of my report which reads EMP and DEPT tables and managed to get it to behave equally.
If anyone wishes to test this in his/hers own environment and see what is happening, here it is:
set pages 58
set newpage 0
set lines 80
set verify OFF
set term ON
set feedback off
set echo OFF
set space 1
set head OFF
SET wrap off
tti OFF
col departure noprint new_value h_departure col company noprint new_value h_company col CurrDate noprint new_value h_CurrDate col mencount noprint new_value h_mencount format 999 col womencount noprint new_value h_womencount format 999 col allcount noprint new_value h_allcount format 999 col passname for a38 hea 'NAME' SELECT to_char(sysdate,'dd.mm.yyyy hh24:mi') CurrDate, 'ACME INC.' COMPANY, 'DEP' departure, 10 MENCOUNT, 10 WOMENCOUNT, 20 ALLCOUNT FROM DEPT WHERE ROWNUM = 1 ;
spool TESTREP.LST
tti left h_company -
col 32 'TEST LIST' col 76 sql.pno format 999 -
skip 'TESTREP.sql' col 32 h_CurrDate -
skip 2 -
left h_departure -
skip 2 'Count:' h_MENCOUNT ' men,' h_womencount ' women, total of '
h_allcount skip 2
;
set head ON
SELECT ENAME PASSNAME FROM EMP;
spool OFF
tti OFF
(Our Oracle version is 8.1.6) Received on Thu Aug 23 2001 - 20:19:49 CEST