Xref: alice comp.databases.oracle.misc:30595 comp.databases.oracle.server:48383 comp.databases.oracle.tools:24400
Path: alice!news-feed.fnsi.net!netnews.com!newspeer.monmouth.com!nntp.flash.net!news.flash.net!not-for-mail
Message-ID: <3730EC44.1CD97108@flash.net>
From: Al Ruiz <arruiz@flash.net>
X-Mailer: Mozilla 4.04 [en]C-NECCK  (Win95; I)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
Subject: Re: HELP  (How to export a table to a delimetered text file)
References: <FAt5Fw.D0G@midway.uchicago.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 17
Date: Thu, 06 May 1999 01:04:35 GMT
X-Complaints-To: abuse@flash.net
X-Trace: news.flash.net 925952675 38.30.171.74 (Wed, 05 May 1999 20:04:35 CDT)
NNTP-Posting-Date: Wed, 05 May 1999 20:04:35 CDT
Organization: FlashNet Communications, http://www.flash.net

You can use pro*c to get the data and write to a file, you can write a
PL/SQL script, if you decide to use the PL/SQL script, you will have to
specify the ULT_FILE_DIR=directory_name in the inti.ora initialization
file.  The you can use the functions FOPEN(), the procedure PUT(),
etc...

Good Luck!

Al Ruiz

Seigmund Akinwande Johnson wrote:

> Help ,
> Does anyone know how to do this ?