Re: Is it possible to export a table to a txt-file??

Ok,

thanks!!

[Quoted] [Quoted] But how do I write a sql-select to a file? Something like this:

<SQL> select A,B,C.... from TABLE > file

By the way, the link to Tom Kyte's website didn't work..

Øyvind

[Quoted] "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:th4g3of7qb0pd3_at_beta-news.demon.nl...
>
> "Øyvind Skjold" <o-skjold_at_online.no> wrote in message
> news:dIqQ6.2031$lM3.44341_at_news1.oke.nextra.no...
> > Hey,
> >
> > I've a problem saving tables through ODBC - ACCESS. The files get so
> > incredible huge..
> > So I'm wondering if it's possible to export directly to a txt-compatible
> > file..( with predefined fieldlength )?? Or isn't it possible??
> >
> > I'm pretty new i the game, so you have excuse me if it's a silly
 question
> > :-)
> >
> > Øyvind.
> >
> >
> >
> >
>
> You have several options
> 1 download the flat file utility from Tom Kyte's website
> (http:///osi.oracle.com/~tkyte)
> 2 Use Toad for this purpose if you already have it
> 3 Write your own select
>
> I do not however believe the size of the file is really going to change.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
>
Received on Sat Jul 21 2001 - 23:45:01 CEST