Re: How to spool statements too

"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