Re: Export Oracle --> text ? Help me please !

From: PIERRE HIRTH <phirth_at_club-internet.fr>
Date: Tue, 8 May 2001 22:05:47 +0200
Message-ID: <9d9jg2$a3o$1@front5m.grolier.fr>

Use the spool command in sqlplus or srvmgrl

Sqlplusw > connect toto/toto
spool c:\temp\myfile.txt
select * from mytable
spool off

"Arnaud" <arnaudr95_at_free.fr> a écrit dans le message news: ZqBJ6.6140$Cr3.531510_at_loualaba.paris.none.net...
> Hi everybody (sorry for my english i'm french ...)
>
> I need to supervise some manipulations on a SGBD oracle. I could not use
> documentation (we go to see a customer with oracle but we don't have
oracle
> to our office).
> The question is :
> How to export the result of a query in a text file or a dbf file ?
>
> Or how to export the data from a table into a text file or a dbf file ?
>
> I know how to do it with MySql , Access .. it s evident that is possible
in
> Oracle but i don't know how !
> Could you help me ?
> It is quite urgent ...
>
> Thanks a lot
> Arnaud
>
>
>
Received on Tue May 08 2001 - 15:05:47 CDT