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

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