Re: UNLOAD function

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: 2000/03/03
Message-ID: <89p1iu$ck$1@plo.sierra.com>#1/1

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_at_hotmail.com> wrote in message news:38BFFC68.755DE692_at_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
>
Received on Fri Mar 03 2000 - 00:00:00 CST