Hide SQL > statements in the spool file [message #638792] |
Sun, 21 June 2015 09:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/448e4dee2331261057266f5d92897c15?s=64&d=mm&r=g) |
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
|
|
|
|
|
|
|
|