Home » SQL & PL/SQL » SQL & PL/SQL » spooling is not working
spooling is not working [message #13004] Thu, 17 June 2004 02:37 Go to next message
raji
Messages: 30
Registered: February 2002
Member
when i gave a location for spool file
its generating but no contents in it
i gave like this
spool D:bacres.doc
sql
Re: spooling is not working [message #13009 is a reply to message #13004] Thu, 17 June 2004 04:18 Go to previous messageGo to next message
pooja
Messages: 31
Registered: September 1999
Member
hai its working for me re...
here is wat i did....

SQL> spool d:sreeres.doc
SQL> select * from test;

NO NAME
----------- ----------
1 aaa
5 nnn
7 lll
3 aaa
2 bbb
11 aaa
10 aaa
999 ghjgjh
666 YUK
555 WRE
100 bbbb
99 HFFGF

12 rows selected.

SQL> spool off
after that goto that path and open the res.doc file. i have the same contents in it as follows:
SQL> select * from test;

NO NAME
----------- ----------
1 aaa
5 nnn
7 lll
3 aaa
2 bbb
11 aaa
10 aaa
999 ghjgjh
666 YUK
555 WRE
100 bbbb
99 HFFGF

12 rows selected.

SQL> spool off
plz try once again...
Re: spooling is not working [message #13010 is a reply to message #13004] Thu, 17 June 2004 04:23 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA
Senior Member
Did you include "spool off" at the end? Try this:

spool d:bacres.doc
select 'this is a test of spooling to d:bacres.doc' from dual;
spool off
edit d:bacres.doc
Re: spooling is not working [message #13013 is a reply to message #13009] Thu, 17 June 2004 07:51 Go to previous messageGo to next message
raji
Messages: 30
Registered: February 2002
Member
thanks
how can i append to this file
if the file contians already some results i dont want to
overwrite i just want to append it
how to do i i want the multiple results have to appended one file
is there any way
with
regards
raji
Re: spooling is not working [message #13022 is a reply to message #13013] Thu, 17 June 2004 20:57 Go to previous message
Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA
Senior Member
spool res2.doc
select sysdate from dual;
spool off
host copy res.doc + res2.doc res.doc
ed res.doc
Previous Topic: sql statement to retrieve a non distinct list
Next Topic: unsubscribe
Goto Forum:
  


Current Time: Thu Jun 18 04:59:33 CDT 2026