Re: Dumping oracle table to ascii delimited file?
From: Dagmar A. Bogan <dagmar_at_indian.mitre.org>
Date: 11 Jan 1994 12:49:43 GMT
Message-ID: <2gu798$e67_at_linus.mitre.org>
The opinions expressed herein do not necessarily reflect those of The MITRE Corporation.
Date: 11 Jan 1994 12:49:43 GMT
Message-ID: <2gu798$e67_at_linus.mitre.org>
It is easy; and you have two options:
- Write SQL to include delimiters, and spool the output to a file i.e.:
SELECT column1||';'||column2||';'||columnn...
2. Use EXPORT.
The opinions expressed herein do not necessarily reflect those of The MITRE Corporation.
Dagmar Anne Bogan * Software Engineering Center * The MITRE Corporation * phone: 703.883.6093 M/S Z676 * fax: 703.883.6991 7525 Colshire Drive * email: dagmar_at_indian.mitre.org McLean, Virginia 22102-3481 *Received on Tue Jan 11 1994 - 13:49:43 CET
******************************************************************************