Re: How to spool statements too

From: Terry Dykstra <>
Date: Thu, 14 Aug 2008 15:43:53 GMT
Message-ID: <ZoYok.7058$%b7.6970@edtnps82>

"Norbert Pürringer" <> wrote in message
> Hello,
> I would like to spool an Oracle SQL script. Now, if I have started a
> spool in SQL Plus, each statement and its result is going to be logged
> in a text file. But if I want to spool an SQL script, only the results
> are spooled, but not the respective statements. Is there a chance to
> spool the executed statements of an SQL script too?
> Thank you,
> Norbert

A simple test script x.sql:

set echo on
set feedback on
set verify on
set termout on

spool x.lst
select sysdate from dual;
spool off

Terry Dykstra
Received on Thu Aug 14 2008 - 10:43:53 CDT

Original text of this message