how to get sql query output into text file without spool statement [message #497796] |
Mon, 07 March 2011 04:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/2df64ef8719499debd7688ce84dc4f97?s=64&d=mm&r=g) |
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....
|
|
|
|