Dump Ascii File From Oracle 6
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Fri, 02 Dec 1994 12:04:00 -0500
Message-ID: <12a.8187.905_at_compudata.com>
Internet: barry.roomberg_at_compudata.com (Barry Roomberg) This message was processed by NetXpress from Merlin Systems Inc.
Received on Fri Dec 02 1994 - 18:04:00 CET
Date: Fri, 02 Dec 1994 12:04:00 -0500
Message-ID: <12a.8187.905_at_compudata.com>
-> 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?
select '"'||field1||'","'||field2||'" from table;
Internet: barry.roomberg_at_compudata.com (Barry Roomberg) This message was processed by NetXpress from Merlin Systems Inc.
Received on Fri Dec 02 1994 - 18:04:00 CET