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>


It is easy; and you have two options:

  1. 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

Original text of this message