OraFAQ Forum: SQL & PL/SQL » spooling is not working

Home » SQL & PL/SQL » SQL & PL/SQL » spooling is not working

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

spooling is not working [message #13004]

Thu, 17 June 2004 02:37

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

Report message to a moderator

Re: spooling is not working [message #13009 is a reply to message #13004]

Thu, 17 June 2004 04:18

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...

Report message to a moderator

Re: spooling is not working [message #13010 is a reply to message #13004]

Thu, 17 June 2004 04:23

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

Report message to a moderator

Re: spooling is not working [message #13013 is a reply to message #13009]

Thu, 17 June 2004 07:51

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

Report message to a moderator

Re: spooling is not working [message #13022 is a reply to message #13013]

Thu, 17 June 2004 20:57

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

Report message to a moderator

Previous Topic:	sql statement to retrieve a non distinct list
Next Topic:	unsubscribe

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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