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

"Norbert Pürringer" <thalion77 (AT) graffiti (DOT) net> wrote

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

"Norbert Pürringer" <thalion77 (AT) graffiti (DOT) net> wrote

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

"Norbert Pürringer" <thalion77 (AT) graffiti (DOT) net> wrote

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

"Norbert Pürringer" <thalion77 (AT) graffiti (DOT) net> wrote

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

On 14 Aug, 16:27, Norbert Pürringer <thalio... (AT) graffiti (DOT) net> wrote:
SET ECHO ON

HTH

-g

On 14 Aug, 16:27, Norbert Pürringer <thalio... (AT) graffiti (DOT) net> wrote:
SET ECHO ON

HTH

-g

On 14 Aug, 16:27, Norbert Pürringer <thalio... (AT) graffiti (DOT) net> wrote:
SET ECHO ON

HTH

-g

On 14 Aug, 16:27, Norbert Pürringer <thalio... (AT) graffiti (DOT) net> wrote:
SET ECHO ON

HTH

-g