Re: exporting text files

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 26 Sep 1998 18:45:58 GMT
Message-ID: <361927e3.9639766@netnews.worldnet.att.net>

On Fri, 25 Sep 1998 21:08:49 GMT, lshea_at_earthling.net wrote:

> just delimited by something and having all fields. Is
>there a SQL-Unload?

Amazing as it may seem, there is not. However, you can use SQL*Plus to pull data out of oracle and place it into a text file. Do something like the following:

set pagesize 0
set heading off

spool c:\a\my_output_file.txt
select col1 || ',' || col2 || ',' || col3 from my_table
where col1=whatever;

spool off

The above would get you comma delimited data.

Jonathan Received on Sat Sep 26 1998 - 13:45:58 CDT