how to save the data of a query in a spool file in oracle

Question

I have created a script which is containing one query and , that query output should print in a spool file.

spool D:\sqlpractice\abcd

it creates the abcd file but that output data is not printing on that file. that output of query is printing on the sqlplus command prompt.

how to save that data in spooled file?

You must end the script with `spool off` – J. Chomel Nov 30 '17 at 06:36 — J. Chomel, Nov 30 '17 at 06:36
okay, I got it now, thanks. – srikanth peddini Nov 30 '17 at 07:08 — srikanth peddini, Nov 30 '17 at 07:08

score 0 · Answer 1 · answered Dec 01 '17 at 10:04

0

You need to use spool off, at that moment the output gets saved to the spoolfile.
For example:

spool D:\sqlpractice\abcd
SELECT * FROM Dual; 
spool off;

answered Dec 01 '17 at 10:04

Tenzin

1 Answers1