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?

alexherm · Accepted Answer · 2020-01-27 19:44:06Z

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, 2020 at 19:44

alexherm

1,3502 gold badges21 silver badges35 bronze badges

answered Mar 10, 2015 at 15:29

Atilla Ozgur

14.8k3 gold badges54 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

matip Over a year ago

I made a query that returns only one row and now in the file there is also line "spool off" but still no results

Atilla Ozgur Over a year ago

@AlexPoole As I understand, commenter clearly says "When I try SPOOL"

Atilla Ozgur Over a year ago

I read it differently, but I found most likely culprit therefore no need for beating around the bush.

matip Over a year ago

Thanks a lot mate. I was using run statment the whole time. Using run script works just fine. What a stupid mistake :P

Atilla Ozgur Over a year ago

@matip If this saved your problem, please accept my answer.

Dave Costa · Accepted Answer · 2015-03-10 16:56:48Z

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, 2015 at 16:56

Dave Costa

48.3k8 gold badges61 silver badges73 bronze badges

Collectives™ on Stack Overflow

SPOOL command doesnt save result in query

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related