SPOOL command doesnt save result in query

sql oracle-sqldeveloper spool
matip picture matip · Mar 10, 2015 · Viewed 9.5k times · Source

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?

Answer

Atilla Ozgur picture Atilla Ozgur · Mar 10, 2015

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

Related questions

How to use spool command in sql developer oracle

Dears, I cannot use spool command. It is not working or i am not doing something right. I am trying to save query result in txt file (tried also csv saving with select /*csv*/ * from table but it also did …

Read More
Use tnsnames.ora in Oracle SQL Developer

I am evaluating Oracle SQL Developer. My tnsnames.ora is populated, and a tnsping to a connection defined in tnsnames.ora works fine. Still, SQL Developer does not display any connections. Oracle SQL Developer Soars mentions, that if you have …

Read More
How can I find which tables reference a given table in Oracle SQL Developer?

In Oracle SQL Developer, if I'm viewing the information on a table, I can view the constraints, which let me see the foreign keys (and thus which tables are referenced by this table), and I can view the dependencies to …

Read More