From: "Steve McDaniels" <steve.mcdaniels@sierra.com>
Subject: Re: UNLOAD function
Date: 2000/03/03
Message-ID: <89p1iu$ck$1@plo.sierra.com>#1/1
References: <38BFFC68.755DE692@hotmail.com>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Complaints-To: usenet@plo.sierra.com
X-Trace: plo.sierra.com 952109470 404 209.67.71.100 (3 Mar 2000 18:51:10 GMT)
Organization: Sierra On-Line, Inc.
X-MSMail-Priority: Normal
NNTP-Posting-Date: 3 Mar 2000 18:51:10 GMT
Newsgroups: comp.databases.oracle.server


There is no Oracle-supplied tool for this other than SPOOL in SQL*Plus.

Here's some SQL*Plus settings to help get started:

set termout off
set pagesize 0
set linesize 1500            or whatever line size you want
set space 0
set trimout on
set feedback off

spool your_file_name.txt

select * from table

spool off
exit


"d_taggart" <d_taggart@hotmail.com> wrote in message
news:38BFFC68.755DE692@hotmail.com...
> I am looking for a function in Oracle  to perform what Sybase does with
> its BCP utility.  Another word, I would like to offload the content of
> an Oracle table in some form of ASCII delimted format.  Is this
> possible?  Thanks
>