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

From: Arnaud <arnaudr95_at_free.fr>
Date: Wed, 09 May 2001 14:45:27 GMT
Message-ID: <bKcK6.1364$jU6.1643637@nnrp6.proxad.net>

It is exactly what i want ... i go tomorrow to the society. Many thank pierre !

Arnaud.

"PIERRE HIRTH" <phirth_at_club-internet.fr> a écrit dans le message news: 9d9jg2$a3o$1_at_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 Wed May 09 2001 - 09:45:27 CDT