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?
See Question&Answers more detail:os