Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Wich SET command I can use...

Status
Not open for further replies.

isonlyme

Programmer
Apr 20, 2002
171
PR
Hi guys

I'm sending a result of an SQL to a file via SPOOL command in SQLplus, but i get this result:

SQL>

Myname 00001111 Notinwork

SQL>spool off

I need to get rid of the "SQL>" and "SQL>spool off" text

Wich set command i should use?

Thanks in advance!!!!


 
set pagesize 0
set heading off
set feedback off
spool Script.sql
select 'Myname 00001111 Notinwork' from dual;
spool off
set heading on
set feedback on
@Script
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top