Hide SQL > statements in the spool file [message #638792] |
Sun, 21 June 2015 09:54 |
|
kiranrathodkr916
Messages: 36 Registered: March 2014 Location: India
|
Member |
|
|
I want to hide the "SQL> @test.sql" and "SQL> spool off" in the file test.txt(spool file)
my steps
set heading off
set pages 0
set trimspool on
set lines 120
set feedback off
set echo off
set termout off
spool test.txt
@test.sql
spool off
test.txt
SQL> @test.sql
2002452199 2797 9/1/2014 9/30/2014 OO56128665 934 90087318 1 6046
10226342 ########## 0 0
SQL> spool off
|
|
|
|
|
|
|
|