Re: Dump Ascii File From Oracle 6
From: Eric Pierce <sac50216_at_saclink1.csus.edu>
Date: 2 Dec 1994 21:26:06 GMT
Message-ID: <3bo3de$ppb_at_news.csus.edu>
Date: 2 Dec 1994 21:26:06 GMT
Message-ID: <3bo3de$ppb_at_news.csus.edu>
Jeff Gerth (jeffg_at_elpaso.cartotech.com) wrote:
: I'm trying to dump oracle table data to an comma delimited ascii file...
: I'm sure there has to be a convenient way of doing this, but I have yet
: to find it.... This is in the PC based version of oracle 6... any
: suggestions?
:
: J.G.
How about:
set space 0 spool roadappl select field1, ',', field2, ',', field3 from your_table / spool off
A potential problem is getting rid of the right padded spaces for character data and left padded spaces for numeric data.
Use RTRIM(char_field) and LTRIM(num_field) if this is a problem.
EP Received on Fri Dec 02 1994 - 22:26:06 CET