1

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!

rcmv
  • 151
  • 2
  • 3
  • 14

1 Answers1

2

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.

Community
  • 1
  • 1
Atilla Ozgur
  • 14,339
  • 3
  • 49
  • 69
  • `Run Script` really does the trick as compared to `Run Statement`. Can anybody shed some light on this? – Semmel Aug 29 '17 at 07:28