Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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 DBAReceived on Wed Apr 06 2005 - 12:35:29 CDT
![]() |
![]() |