Re: unload table

"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 ?
>
> thanks in advance
>
> Dale Stewart

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 Received on Tue Feb 03 2004 - 05:21:28 CST