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

A copy of this was sent to "Øyvind Skjold" <o-skjold_at_online.no> (if that email address didn't require changing) On Mon, 28 May 2001 14:25:22 +0200, you wrote:

>Ok,
>
>thanks!!
>
>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..
>

they put an extra slash in there which if you would have removed it -- it would have worked

see
http://osi.oracle.com/~tkyte/flat/index.html

>Øyvind
>
>
>"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
>>
>>
>>
>

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/ http://asktom.oracle.com/~tkyte/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp