Home » Other » Client Tools » spool without user respons
spool without user respons [message #246805] Fri, 22 June 2007 01:12 Go to next message
ddaannyy
Messages: 13
Registered: March 2007
Junior Member
Hi

my problem is, that i want not get a ask like below, if i start my sql-statement:

test: SQL> @script.sql;
Weiter: <RETURN>, Abbruch: <CTRL + C>


My script.sql looks like so:

set linesize 200;
set pagesize 10000;
set heading on;
set colsep ' ';
spool /out/script.cvs;

select ...

spool off;
exit;

If i let it running with pagesize 0 it works, but then i get not the first line. Mad
Re: spool without user respons [message #246822 is a reply to message #246805] Fri, 22 June 2007 01:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set define off

Regards
Michel
Re: spool without user respons [message #246836 is a reply to message #246805] Fri, 22 June 2007 03:09 Go to previous message
ddaannyy
Messages: 13
Registered: March 2007
Junior Member
Thanks it works Razz
Previous Topic: not to display first two columns
Next Topic: some useful tip about sequences
Goto Forum:
  


Current Time: Fri Mar 29 05:51:25 CDT 2024