Home » SQL & PL/SQL » Client Tools » how to get sql query output into text file without spool statement (windows xp)
how to get sql query output into text file without spool statement [message #497796] Mon, 07 March 2011 04:20 Go to next message
swapnabpnn
Messages: 96
Registered: December 2010
Member
Hi All,
I would like to store my sql query output into text file.
Like for example:
select name from emp where emp_id=101;
Here output should be in text file as
swapna.
I dont want to use spool statement here,since If I use it,spool statement will also be printed in text file which is not my requirement.I just want to take only output.
How can I write this??
Thanks....
Re: how to get sql query output into text file without spool statement [message #497800 is a reply to message #497796] Mon, 07 March 2011 04:33 Go to previous message
ThomasG
Messages: 3205
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
swapnabpnn wrote on Mon, 07 March 2011 11:20
since If I use it,spool statement will also be printed in text file


You can switch that off with set echo off before you start to spool.
Previous Topic: Oracle connection to SQL server
Next Topic: dump in Toad version 9.7.2
Goto Forum:
  


Current Time: Tue Jan 23 05:01:09 CST 2018

Total time taken to generate the page: 0.02774 seconds