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

text save output spool
Adam Brave picture Adam Brave · Mar 5, 2015 · Viewed 25.5k times · Source

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!

Answer

Atilla Ozgur picture Atilla Ozgur · Mar 10, 2015

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.

Related questions

How to draw text On image?

I want to draw text on image ( for saving that image with text ). i have image view i set bitmap to that image i want to Draw the text on image (text entered by user ). i tried this before saving..... …

Read More
TypeError: Mismatch between array dtype ('object') and format specifier ('%.18e')

I have the following array: X = np.array([image_array_to_vector1,image_array_to_vector2,image_array_to_vector3,image_array_to_vector4]) A print out of X looks as follows: [array([167, 167, 169, ..., 1, 1, 1], dtype=uint8) array([42, 43, 43, ..., 41, 36, 34], dtype=uint8) array([0, 0, 0, ..., 0, 0, 0], dtype=…

Read More
Save Java txt file to folder

First of all - I love you all at Stackoverflow! Everyone is very helpful! Sadly when I go to answer questions they are all too advance for me :'( I want to save the text file to a folder - …

Read More