Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is there a way to direct the select and the output into a file ?

Re: Is there a way to direct the select and the output into a file ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 06 Apr 2005 19:35:29 +0200
Message-ID: <3c7851ti30qpo0ng71qsbttdfttln8v93j@4ax.com>


On 6 Apr 2005 08:56:54 -0700, tpreto7_at_sapo.pt (Teresa) wrote:

>I have a select statement in a file, which I would like to get
>redirected into a file together with the output.
>when I do this
>
>spool test.log
>select count(*) from user_table;
>spool off
>
>only the out put shows, but if I do it directly in a database there is
>no problem???
>does any one know how I can by pass this
>Thanks
>Teresa

No version, no platform, so nothing to work on. However both on Unix and in a Windhose command box, you can redirect the output just like any other command

sqlplus/nolog <username/password>@service @<name of the script> > <any filename>

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Apr 06 2005 - 12:35:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US