rcmv
rcmv

Reputation: 151

SQL Oracle - How to save the query output with spool on a text file?

I'm using spool to save the output of my query into a text file but what is actually doing is save the sql commands into the file.

I have:

SPOOL D:\sqltestes\sql_test.txt
SELECT max(column1) from my_table;
SPOOL OFF;

And this, is writting on the text file the "SELECT max(column1) from my_table;" and not the result of the query... Why?

Help please!

Upvotes: 1

Views: 28983

Answers (1)

Atilla Ozgur
Atilla Ozgur

Reputation: 14701

I assume you are using Sql Developer or Toad. I already answered this one. There is a difference between Run Statement and Run Script. Try Run Script.

Upvotes: 2

Related Questions