Re: How to spool statements too

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


"Norbert Pürringer" <thalion77_at_graffiti.net> wrote in message news:8d51811c-b324-4d93-8b65-aaffe7e971a1_at_e39g2000hsf.googlegroups.com...
> 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