how to get sql query output into text file without spool statement [message #497796] |
Mon, 07 March 2011 04:20 |
|
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....
|
|
|
|