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

Question

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!

Community · Accepted Answer · 2017-05-23 12:28:21Z

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.

edited May 23, 2017 at 12:28

CommunityBot

11 silver badge

answered Mar 10, 2015 at 17:03

Atilla Ozgur

14.8k3 gold badges54 silver badges75 bronze badges

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

1 Comment

Semmel Over a year ago

Run Script really does the trick as compared to Run Statement. Can anybody shed some light on this?

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related