Re: unload table

From: John <Nothanks_at_noaddress.com>
Date: Tue, 3 Feb 2004 13:27:04 +0000 (UTC)
Message-ID: <Xns9484890605866Nothanksnoaddresscom@127.0.0.1>

"Guido Konsolke" <GK_at_oblivion.com> wrote in news:1075806009.68957 @news.thyssen.com:

> "BlindStag" wrote...

>> Hi all,
>>
>> I'm new to oracle, and want to know if there is a utility in oracle
>> (similar to the unload utility in Informix), that lets you

> unload/output a

>> table in a comma or pipe delimited format. If not, How does one do
> it ?

>
> Hi Dale,
>
> I think the tool you're looking for is: SQL*PLUS. It's part of what
> comes
> with the rdbms (and other products). In sql*plus you can spool the
> table
> data to a file -> check out the command SPOOL. To put delimiters
> between
> the columns -> check out the command COLSEP. Some other commands
> can give you a more convenient output. Just check the manuals about
> them.
>
> hth,
> Guido
>
>

and sqlldr for the other direction Received on Tue Feb 03 2004 - 07:27:04 CST