SPOOL command doesnt save result in query

Question

I'm using SQL Developer and I'm trying to save result of a query into the text file using spool command.

spool D:\file.txt
SELECT * FROM TABLE
SPOOL OFF

When I open created file it only has my query in it: "SELECT * FROM TABLE" but not result of it. What am I doing wrong?

score 3 · Accepted Answer · edited Jan 27 '20 at 19:44

3

Try to execute it with a query which returns fewer rows to see if you have any other problems. After you make it work, try your query. Also there is a difference between Run Statement and Run Script.

In the following query

spool '/home/atilla/file.txt'

SELECT * FROM DUAL;

SPOOL OFF

If I use Run Statement, I get following file

   \> SELECT * FROM DUAL

If I use Run Script, I get following file

\> SELECT * FROM DUAL
DUMMY
-----
X

edited Jan 27 '20 at 19:44

alexherm

1,362
2
18
31

answered Mar 10 '15 at 15:29

Atilla Ozgur

14,339
3
49
69

I made a query that returns only one row and now in the file there is also line "spool off" but still no results – matip Mar 10 '15 at 15:37
@AlexPoole As I understand, commenter clearly says "When I try SPOOL" – Atilla Ozgur Mar 10 '15 at 16:29
I read it differently, but I found most likely culprit therefore no need for beating around the bush. – Atilla Ozgur Mar 10 '15 at 16:54
Thanks a lot mate. I was using run statment the whole time. Using run script works just fine. What a stupid mistake :P – matip Mar 10 '15 at 16:59
@matip If this saved your problem, please accept my answer. – Atilla Ozgur Mar 10 '15 at 17:00

score 0 · Answer 2 · answered Mar 10 '15 at 16:56

0

It looks to me that you're not executing the query, just entering it into the command buffer. You need to add a semicolon or a slash to actually execute it.

answered Mar 10 '15 at 16:56

Dave Costa

47,262
8
56
72

SPOOL command doesnt save result in query

2 Answers2

Linked