Re: Dump Ascii File From Oracle 6
From: Lawrence James <James.Lawrence_at_epamail.epa.gov>
Date: Tue, 6 Dec 1994 17:57:03 GMT
Message-ID: <James.Lawrence.48.0011F3FD_at_epamail.epa.gov>
Date: Tue, 6 Dec 1994 17:57:03 GMT
Message-ID: <James.Lawrence.48.0011F3FD_at_epamail.epa.gov>
In article <3bldm4$agq_at_nntp.crl.com> jeffg_at_elpaso.cartotech.com (Jeff Gerth) writes:
>From: jeffg_at_elpaso.cartotech.com (Jeff Gerth)
>Subject: Dump Ascii File From Oracle 6
>Date: 1 Dec 1994 21:03:00 GMT
>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.
I used to use SQLPlus and select literals, IE:
SELECT ' " '|| COLUMEA ||' "," ' || COLUMEB || ..... etc
Also set headings off, pagesize to 100000, output off, and spool to a file.
Lawrence.... Received on Tue Dec 06 1994 - 18:57:03 CET