Re: how can i put the result of a sql-statement in a file instead of screen
From: Glen A Stromquist <glen_stromquist_at_no.spam.yahoo.com>
Date: Mon, 14 Jul 2003 16:54:56 GMT
Message-ID: <AfBQa.5935$xn5.939536_at_news0.telusplanet.net>
Date: Mon, 14 Jul 2003 16:54:56 GMT
Message-ID: <AfBQa.5935$xn5.939536_at_news0.telusplanet.net>
P.pan wrote:
> hi to all
>
> I am using sql+ from oracle
>
> I would like to put the result of a sql-statement in a file.
>
> like: select * from xy where ... ???? which parameter do I have to use
> that this result will be in a file instead of the screen.
>
> How can I manage this problem?
>
> Thanx for help
>
> Peter
>
>
spool <filename>
select blah blah blah...
spool off
hth Received on Mon Jul 14 2003 - 18:54:56 CEST